Showing posts with label truncate. Show all posts
Showing posts with label truncate. Show all posts
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
Subscribe to:
Posts (Atom)