List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 6 2000 6:11am
Subject:Re: deleting all rows reports 0 rows affected
View as plain text  
At 3:29 PM -0700 2000-04-05, dlai@stripped wrote:
>  >Description:
>	Deleting all rows of a table using "delete from table_name;" in
>	the mysql client reports 0 rows affected, nomatter how large the
>	table is.

That is how it is documented to work.  See the description of DELETE
in chapter 7 of the MySQL Reference Manual.

-- 
Paul DuBois, paul@stripped
Thread
deleting all rows reports 0 rows affecteddlai6 Apr
  • Re: deleting all rows reports 0 rows affectedPaul DuBois6 Apr