I'm using version 3.23.53 on Win 2k. The same things happens to me.
I've also noticed that if you don't specify a WHERE clause and you have a Auto-incrementing ID field, it is reset to zero and the next record you create starts at 1 again. Surely this is wrong as well? In Other RDBMS's after DELETE * Table. The ID field still remembers the last ID so the next (first) record after performing a delete all, will increment from the last ID. BTW, I've just installed MySQL-Front. It got me up and running in no time! :-) Nick :> -----Original Message----- :> Anybody knows why, then, delete gave me a '0 rows affected' :> message instead :> of saying '1 row affected'? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
