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

• Next in forum: Re: Connection Problem, Driving me insane
• Prev in forum: Re: Grouping system
• Thread view: truncate table vs delete from table

[Reply to this message]