[TYPO3-dev] How standard compliant is "truncate"?

[Peter Kuehn [wmdb]]

 > Yes. TRUNCATE on InnoDB is an alias for DELETE and deletes all
 > rows inside one internal transaction.

erm...
http://dev.mysql.com/doc/refman/5.0/en/truncate.html
http://packages.debian.org/de/etch/misc/mysql-server


Dmitry Dulepov schrieb:
> Hi!
> 
> Martin Kutschker wrote:
>> Is truncate really faster?  I assumed that a DELETE without a WHERE
>> clause will work internally the same as a TRUNCATE.
>>
>> BTW, is there any difference for MyIsam or InnoDB tables?
> 
> Yes. TRUNCATE on InnoDB is an alias for DELETE and deletes all rows inside one internal transaction.
> 
> TRUNCATE on MyISAM is much faster than delete because it just resets row counter to 0. DELETE removes all rows and much slower on MyISAM with many rows.
>