/SQL/Truncate table

Truncate table

Truncate table

TRUNCATE TABLE table;

3

Truncate all tables

SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') 
FROM INFORMATION_SCHEMA.TABLES where  table_schema in ('db1_name','db2_name');

0

Source: stackoverflow.com

Similar codes

1 vote398 views3 answers
Date_add mysql
SQL
0 vote373 views1 answer
Logtash mysql cofiguration file
SQL
-1 vote371 views2 answers
Installing mysql on centos 7
SQL
0 vote346 views1 answer
Oracle sql generate list of days
SQL
1 vote367 views1 answer
Name of today sql
SQL
0 vote353 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote343 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
1 vote339 views1 answer
Search for tables with name postgresql
SQL
13 votes370 views1 answer
Sql join 3 tables on id
SQL
0 vote373 views1 answer
Postgres grep entire database
SQL

Share