Posted by Chris Hope on 06/29/05 00:40

Gordan wrote:

> 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?

I wrote an article about this about a year ago about exactly this (url
below). Note that the behaviors are slightly different depending which
table type and MySQL version you are using.

http://www.electrictoolbox.com/article/mysql/delete-all-data-mysql/

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Back to original message]