I got some problem with index (version 4.0.15) alway corrupt when I try to delete some row my table have 3 index one key make for varchar column the data of this column come from date+number like this
2003-10-28/1/4 2003-10-28/2/4 2003-10-28/3/4 2003-10-28/4/4 .......
that mean in this day 2003-10-28 I have 4 record with running number like 1/4..4/4 every thing work find I can use index from select ,update ,delete (small part)but when I try to delete like delete from xxx where yy=somedate that it have to delete about 800 record the index key above alway corrupt and make deletion only 36 record before corrupt if I delete with limit 20 record no problem occur but I must do many loop to complete deletion. That it may be wrong ?
So when I change type from varchar to varchar binary every thing OK no error I can delete it with out limit
My question why to use binary varchar instead of varchar ??? (if not use it corrupt why it corrupt )
Thanks Kittiphum Worachat,MT.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
