Thursday, September 28, 2017

Truncate all tables from DB

Truncate all tables from DB



SELECT Concat(TRUNCATE TABLE ,table_schema,.,TABLE_NAME, ;)
FROM INFORMATION_SCHEMA.TABLES where  table_schema in (db1, db2);

copy strings and execute




download file now