/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

2 votes114 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote128 views1 answer
How to update sql server version
SQL
0 vote116 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote127 views1 answer
Postgresql custom order by
SQL
4 votes118 views1 answer
Wilayah indonesia sql
SQL
5 votes125 views4 answers
Mysql update column with value from another table
SQL
3 votes117 views2 answers
Sql get month name
SQL
0 vote130 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote133 views1 answer
Psql import backup file for windows
SQL
1 vote121 views1 answer
Continue in sql
SQL

Share