Search the Community
Showing results for tags 'chapter17'.
-
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