Truncate db / table incorrect

[webRat]

FYI: http://www.mysql.com/doc/en/TRUNCATE.html

Quote:

syntax: TRUNCATE TABLE table_name

TRUNCATE TABLE differs from DELETE FROM … in the following ways:

* Truncate operations drop and re-create the table, which is much faster than deleting rows one by one.

* Not transaction-safe; you will get an error if you have an active transaction or an active table lock.

* Doesn't return the number of deleted rows.

* As long as the table definition file `table_name.frm' is valid, the table can be re-created this way, even if the data or index files have become corrupted.

TRUNCATE is an Oracle SQL extension.

[Ritesh]

Hmmmmmmmmmm….

Thanks for the information 😀

[Author]

Posts