Delete all data from table but not the columns

Question

How can I delete all the data in an SQL table, but not delete the columns? I want all the column names and attributes to still be there after the data is deleted.

Answer 1

delete from tablename;

it can also work

truncate table tablename

I didn't read the question

EDIT I checked for

delete from tablename;

it is also working..am i right??downvoters can you please tell the reason

'truncate'..'truncate' is more efficient than 'delete'..

Answer 2

You could either use:

TRUNCATE TABLE `tableName`;

From the MySQL docs:

TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that deletes all rows, but there are practical differences under some circumstances.

You could also use DELETE FROM tableName, but using TRUNCATE TABLE tableName is better because:

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

Answer 3

Please use this syntax in your sql editor

Ex: truncate table tablename

table name: demo

truncate table demo

this will delete only data and not the columns

Answer 4

To delete all content of a table do:

TRUNCATE TABLE `name`

Answer 5

The syntax might vary slightly depending on your database, but you probably want something like:

TRUNCATE TABLE my_table_name;

Also, DELETE FROM my_table_name will also work, but generally be much slower than TRUNCATE.

Answer 6

Did you try the using TRUNCATE??

TRUNCATE TABLE YOUR_TABLE_NAME;