Posted by Gordan on 06/29/05 00:21

Hi,

can somebody explain to me the difference between "TRUNCATE TABLE table1" and
"DELETE FROM table1 WHERE 1=1"
I know that both of these queries will delete all rows, and I also know that
TRUNCATE will reset my auto_increment IDs and DELETE won't. Are there any other
differences?

thanks
gordan

[Back to original message]