select CONCAT('TRUNCATE TABLE mydatabase.',TABLE_NAME,';') FROM information_schema.TABLES WHERE TABLE_SCHEMA='mydatabase'