Just to confirm that this is not a file permissions problem, I can use this statement:
DELETE FROM stock WHERE supplier LIKE '%' and it doesn't exhibit this problem, but a plain: DELETE FROM stock does. I'm thinking that perhaps this is a bug in MySQL but I'm not sure. If anyone has any pointers it would be much appreciated. Cheers Andrew. ----- Original Message ----- From: "Andrew Pattison" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 12:18 PM Subject: Fw: Problem deleting data > > > I have a strange problem with MySQL 4.0.15 . When I delete an entire > table, > > then run a repair on that table, it recovers all the rows which I just > > deleted! Also, if I do a "check table" I can see that the files on disk do > > not appear to have been altered in any way by the delete. Does anyone have > > any clues as to what is going on here? > > > > Thanks > > > > Andrew P. > > > > Andrew Pattison, IT Support > > Sterling Furniture Group Ltd > > 01259 75 5135 > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]