>I'm sure this has been covered somewhere, but when I do something like:
>delete from this_table;
>Query OK, 0 rows affected (0.02 sec)
>Yet, it deletes all the rows out of the table.
>Is this expected? (i did want to delete all the rows, so it's no biggy to
>me, but I did expect it to say that rows were affected).
Yep, it's expected. It's even documented, in the DELETE section
of chapter 7 of the MySQL reference manual. It also says how to get
the count you want, if you're willing to write a slower query.
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
|• Wierd message?||Jim Matzdorff||2 Jul|
|• Re: Wierd message?||Paul DuBois||2 Jul|