/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 vote345 views1 answer
Oracle create as select
SQL
0 vote373 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote357 views2 answers
Advantages of stored procedures sql
SQL
0 vote444 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote349 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
4 votes360 views6 answers
Sql select statement
SQL
0 vote347 views1 answer
Connect to ssms with python
SQL
0 vote330 views1 answer
Sqlite select split string
SQL
0 vote361 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote348 views1 answer
Find wordpress version in database
SQL

Share