CREATE TABLE users (
   id int( 11 ) UNSIGNED auto_increment NOT NULL,
   login varchar( 32 ) NOT NULL,
   pass varchar( 32 ) NOT NULL,
   mail varchar( 128 ) NOT NULL,
   gender char( 1 ) NOT NULL,
   active char( 1 ) NOT NULL,
   logTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   regTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   photoHave int( 1 ) unsigned DEFAULT '0' NOT NULL,
   messNew int( 3 ) unsigned DEFAULT '0' NOT NULL,
   birthDate date DEFAULT '0000-00-00' NOT NULL,
   nick varchar( 128 ) NOT NULL,
   city varchar( 255 ) NOT NULL,
   aboutYou varchar( 255 ) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE KEY (login),
   KEY mainSearch (gender, active, photoHave)
);

SELECT * FROM users WHERE login='1' AND pass='2'

UPDATE LOW_PRIORITY users SET messNew = '2' WHERE login = 'funtik' 

UPDATE LOW_PRIORITY users SET logTime = '2006-01-11 21:36:33' WHERE login = 'rabit' AND pass = '***' 

SELECT * FROM users

 48232    db   webnew1 db2   Query    129    Locked   UPDATE LOW_PRIORITY users SET logTime = '2006-01-12 16:10:07' WHERE login = 'olga21' AND pass = '***'  

SELECT * FROM users
WHERE login = 'olga21' AND pass = '***' 

table  users 
type   const 
possible_keys  PRIMARY 
key PRIMARY  
key_len   32  
ref  olga21 
rows   1 
Extra