/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

13 votes176 views6 answers
Restart postgresql
SQL
0 vote178 views1 answer
Replace multiple string in query sql
SQL
0 vote178 views1 answer
Mysql sql select one day before
SQL
0 vote188 views1 answer
Wordpress sql change site url
SQL
2 votes213 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote181 views1 answer
Sql server whoami
SQL
0 vote181 views4 answers
First max salary in sql
SQL
6 votes196 views3 answers
Sql select last id
SQL
5 votes178 views2 answers
Oracle to_timestamp
SQL
0 vote213 views1 answer
Ubuntu connect to mssql database
SQL

Share