/SQL/Sql empty table

Sql empty table

Sql empty table

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With possible rollback
DELETE FROM my_table;
COMMIT;  -- or ROLLBACK;

4

Truncate table

TRUNCATE TABLE table;

3

Similar codes

0 vote268 views1 answer
Set a default value for a column in sqlite
SQL
0 vote268 views1 answer
Postgres sql alter table delete row
SQL
3 votes307 views1 answer
Sql double index
SQL
0 vote263 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote232 views1 answer
How to set field to null in sql
SQL
0 vote272 views1 answer
Mysql disable query caching
SQL
3 votes288 views1 answer
Postgresql if null then 0
SQL
0 vote262 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote262 views1 answer
How to query all tables mysql at the same time
SQL
0 vote263 views1 answer
Mariadb mysql root access denied
SQL

Share