Prathik Rajendran M prathik

Still learning!

prathik / truncate_tables.sql

Last active February 18, 2019 11:20

Mysql Query to generate TRUNCATE TABLE command for all tables in given databases

	SELECT
	GROUP_Concat(CONCAT('TRUNCATE TABLE ',
	table_schema,
	'.',
	TABLE_NAME) SEPARATOR '; ' )
	FROM
	INFORMATION_SCHEMA.TABLES
	where
	table_schema in (
	'db1', 'db2'