http://www.mysql.com/doc/D/E/DELETE.html
"In MySQL 3.23, DELETE without a WHERE clause will return zero as the number of affected records." Alain Fontaine Consultant & developer VAlain S.A. http://www.valain.lu/ -----Message d'origine----- De : Bhavin Vyas [mailto:[EMAIL PROTECTED]] Envoyé : lundi 15 juillet 2002 18:40 À : [EMAIL PROTECTED] Objet : Interesting 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 --------------------------------------------------------------------- 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
