/SQL/How to truncate all table in mysql workbench

How to truncate all table in mysql workbench

How to truncate all table in mysql workbench

SELECT
    Concat('TRUNCATE TABLE ', TABLE_NAME)
FROM
    INFORMATION_SCHEMA.TABLES
WHERE
    table_schema = 'db_name';

0

Source: tableplus.com

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

0 vote117 views4 answers
How to drop all tables in sql
SQL
2 votes114 views2 answers
Storing timezones in postgres
SQL
9 votes102 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote123 views2 answers
Compound operator in sql
SQL
-1 vote58 views3 answers
Ubuntu install mssql
SQL
1 vote108 views1 answer
Oracle undo usage per session
SQL
0 vote127 views1 answer
Python dictionary to sql update
SQL
0 vote107 views1 answer
Sql not exists
SQL
3 votes109 views1 answer
How to check schema privileges in oracle
SQL
12 votes120 views1 answer
Create column sql server
SQL

Share