|
1878.5.5
by Brian Aker
Additional documentation. |
1 |
TRUNCATE
|
2 |
========
|
|
3 |
||
|
1994.4.119
by Marisa Plumb
doc fixes and additions |
4 |
This will delete all data in a table but unlike a DROP TABLE it will allow you to keep the table in your database. |
|
1878.5.5
by Brian Aker
Additional documentation. |
5 |
|
|
2165.2.5
by Andrew Hutchings
Make fixes to temporal docs |
6 |
.. code-block:: mysql |
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
7 |
|
|
1945.3.9
by Marisa Plumb
changes in cross-references |
8 |
TRUNCATE TABLE table_name |
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
9 |
|
10 |
TRUNCATE TABLE is typically faster than a DELETE * FROM TABLE query. An |
|
|
1994.4.119
by Marisa Plumb
doc fixes and additions |
11 |
unbounded DELETE query will have to generate log data for every |
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
12 |
row in the table, which could be quite large. TRUNCATE TABLE is the same |
13 |
as DROP followed by CREATE except that the absence of the table between |
|
|
1994.4.119
by Marisa Plumb
doc fixes and additions |
14 |
DROP and CREATE is not exposed. |