MySQL Forums
Forum List  »  Memory Storage Engine

Advanced Search
New Topic

Re: Problem with index on MEMORY table type, MySQL 4.1.8
Posted by: Samuel Benzaquen
Date: April 07, 2005 02:34PM

Actually, I'm having a problem similar.
I try a DELETE with WHERE and it only deletes the first matched row.
If I do WHERE date='date' ORDER BY 1+1 it works perfectly.

If I drop they index on that column and recreate it, the statement work _for a while_. After something that I haven't figured out happens, it starts to malfunction again, just deleting one row at a time.

-SamSam

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Problem with index on MEMORY table type, MySQL 4.1.8
7055
Steve Huth
February 22, 2005 01:26PM
Re: Problem with index on MEMORY table type, MySQL 4.1.8
4555
Samuel Benzaquen
April 07, 2005 02:34PM
Re: Problem with index on MEMORY table type, MySQL 4.1.8
4532
Samuel Benzaquen
April 12, 2005 07:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.