At 8:03 AM -0600 1/16/99, root wrote: >>Description: > A mass delete such as "delete from stock;" works correctly by > deleting all rows, however mySQL reports "0 rows affected". > The 0 report happens in interactive "mysql" as well as in C++ > programs written to check the MysqlResNSel structure. I've > been using the C++ classes mysql++ v64.1.1.a. This prevents > a programmer from programmatically determining how many > rows were affected by a mass delete and taking a different > branch in the code if the number affected was > 0. This is the documented behavior. See the description of the DELETE statement in chapter 7 of the manual. If you want to know how many rows are in the table, you could run SELECT count(*) FROM tbl_name first... -- Paul DuBois, [EMAIL PROTECTED] Northern League Chronicles: http://www.snake.net/nl/ Madison Black Wolf: http://www.primate.wisc.edu/people/dubois/blackwolf/ ----------------------------------------------------------- Send a mail to [EMAIL PROTECTED] with unsubscribe mysql [EMAIL PROTECTED] in the body of the message to unsubscribe from this list.
