Bhavin,
Monday, July 15, 2002, 7:39:52 PM, you wrote:
BV> I did a select * as such:
BV> mysql> select * from Sqs;
BV> +-------------+---------+--------+
BV> | RecordState | Sqs | SqsKey |
BV> +-------------+---------+--------+
BV> | L | unknown | 1 |
BV> +-------------+---------+--------+
BV> 1 row in set (0.00 sec)
BV> Then, look at the message that delete from gives me '0 rows affected'
BV> mysql> delete from Sqs;
BV> Query OK, 0 rows affected (0.02 sec)
BV> However, it did indeed delete one row, since now I get an empty set when I
BV> do a select *.
BV> mysql> select * from Sqs;
BV> Empty set (0.00 sec)
BV> Anybody knows why, then, delete gave me a '0 rows affected' message instead
BV> of saying '1 row affected'?
Because you are using DELETE statement without WHERE clause. It's
described in the MySQL manual:
http://www.mysql.com/doc/D/E/DELETE.html
In this case MySQL simply re-creates table.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
