I did a select * as such: mysql> select * from Sqs; +-------------+---------+--------+ | RecordState | Sqs | SqsKey | +-------------+---------+--------+ | L | unknown | 1 | +-------------+---------+--------+ 1 row in set (0.00 sec)
Then, look at the message that delete from gives me '0 rows affected' mysql> delete from Sqs; Query OK, 0 rows affected (0.02 sec) However, it did indeed delete one row, since now I get an empty set when I do a select *. mysql> select * from Sqs; Empty set (0.00 sec) Anybody knows why, then, delete gave me a '0 rows affected' message instead of saying '1 row affected'? Mysql version 3.23.49 Regards, Bhavin. --------------------------------------------------------------------- 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