Problem with indexes

2004-02-25 Thread James Lamanna
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

Re: Problem with indexes

2004-02-25 Thread James Lamanna
: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

Re: Problem with indexes

2004-02-25 Thread James Lamanna
Yes. [EMAIL PROTECTED] wrote: I am assuming that the Memo field is a text datatype and you were encountering the duplicate key bug. Original Message On 2/25/04, 3:28:58 PM, James Lamanna [EMAIL PROTECTED] wrote regarding Re: Problem with indexes: Found out that the problem was actually