I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686) I created the following table without error. The index line should have prevented the success of the command.
CREATE TABLE IF NOT EXISTS catalog.junk ( hat VARCHAR(14) DEFAULT '' NOT NULL, hats VARCHAR(14) DEFAULT '' NOT NULL, house VARCHAR(14) DEFAULT '' NOT NULL, houses VARCHAR(14) DEFAULT '' NOT NULL, KEY hats (hats,house,house,house,house,house) ) TYPE = ISAM; As you can see the field `house' is repeated in the `KEY' line Barry --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php