At 18:13 -0500 2/15/03, Barry Pollock wrote:
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.
It may not make any sense, true, but it's not syntacticallyy invalid.
You'll probably also find that you can create the same index multiple times.
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
