MySQL Forums
Forum List  »  Memory Storage Engine

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with index on MEMORY table type, MySQL 4.1.8
4485
April 07, 2005 02:34PM


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.