"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/truncate.rst" (6 May 2012, 498 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

TRUNCATE

This will delete all data in a table but unlike a DROP TABLE it will allow you to keep the table in your database.

TRUNCATE TABLE table_name

TRUNCATE TABLE is typically faster than a DELETE * FROM TABLE query. An unbounded DELETE query will have to generate log data for every row in the table, which could be quite large. TRUNCATE TABLE is the same as DROP followed by CREATE except that the absence of the table between DROP and CREATE is not exposed.