Results 1 to 5 of 5
Thread: Question about MySQL Indexes
Jul 20, 2012, 03:28 #1
Question about MySQL Indexes
So if I have a table with a structure as below:
CREATE TABLE `employee` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `full_name` INT(64) NOT NULL, `email` VARCHAR(255) NOT NULL, `mobile` VARCHAR(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), UNIQUE KEY `mobile` (`mobile`) ) ENGINE=MYISAM DEFAULT CHARSET=latin1
SELECT * FROM employee WHERE firstname.lastname@example.org'
Will the index work in this case? (notice the unique index assigned)
Thanks for any inputs.