Can you do a show create table Table1 and see how the index is defined? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTECTED]> wrote regarding Problem with indexes: > So I'm having issues with indexes in mysql 4.0 > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]