Gili,
if all rows are affected (as in your case) MySQL just discards the whole
table content at once so it cannot return the number of affected rows.
If you are interested in it put a dummy where clause into your statement
such as 'where 1>0'. That causes MySQL to delete row by row and then it
will give you the right number.
Regards,
Frank.
sl wrote:
>
> When I execute "DELETE FROM VALID_CACHE;" where VALID_CACHE is
> the name of a table I get "0 rows affected" even if multiple rows are deleted..
>
> I am expecting the return value to be the number of rows which were removed.
>
> I await your response (please respond by email).
>
> Thank you,
> Gili
>
> ---------------------------------------------------------------------
> 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
--
Dr. Frank Ullrich, Netzwerkadministration
Verlag Heinz Heise GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587; FAX: +49 511 5352 538
---------------------------------------------------------------------
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
