Hi Great day,
can anyone explain me this line of code ... "INDEX login(username, pass)" in the below query
*************************************************************************
CREATE TABLE users (
user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
lang_id TINYINT UNSIGNED NOT NULL,
time_zone VARCHAR(30) NOT NULL,
username VARCHAR(30) NOT NULL,
pass CHAR(40) NOT NULL,
email VARCHAR(60) NOT NULL,
PRIMARY KEY(user_id),
UNIQUE (username),
UNIQUE (email),
INDEX login(username, pass)
);
**********************************************************
Thanks in advance,
sharma