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
: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
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