List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 2 1999 4:45am
Subject:Re: Wierd message?
View as plain text  
>I'm sure this has been covered somewhere, but when I do something like:
>delete from this_table;
>I get:
>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:
Wierd message?Jim Matzdorff2 Jul
Re: Wierd message?Paul DuBois2 Jul