/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 vote141 views1 answer
Intellij mysql set timezone
SQL
0 vote148 views1 answer
Oracle swap partition
SQL
22 votes145 views3 answers
How to join three tables in sql using joins
SQL
2 votes146 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote150 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
3 votes141 views2 answers
Sqlite print all column names
SQL
2 votes191 views2 answers
Create table mysql integer NOT null
SQL
2 votes142 views1 answer
Date conversion in mysql column
SQL
-1 vote129 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
1 vote141 views1 answer
MySQL AND Operator
SQL

Share