I issue the following: Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to insert into this table using INSERT I'm receiving errors about duplicate keys against this Index.
I thought this Index should be non-unique since I didn't specify the UNIQUE keyword.
This table does not have a Primary Key either. Kinda need help ASAP, so any ideas would be appreciated.
Thanks.
-- James Lamanna
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]