/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 vote286 views1 answer
Mysql config address
SQL
0 vote272 views1 answer
Sql server alter table column nullable
SQL
0 vote258 views1 answer
Postgressql uuid
SQL
0 vote258 views1 answer
How to use lower case in mysql
SQL
21 votes264 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
11 votes269 views2 answers
Turn off safe mode mysql
SQL
0 vote269 views1 answer
Mysql undo delete
SQL
0 vote284 views1 answer
Count columns psql(PostreSQL)
SQL
15 votes280 views5 answers
Show tables in oracle
SQL
1 vote269 views1 answer
How to change owner in postgres
SQL

Share