清空数据库内的所有表数据

SELECT
    CONCAT( 'truncate TABLE ', table_schema, '.', TABLE_NAME, ';' ) 
FROM
    INFORMATION_SCHEMA.TABLES 
WHERE
    table_schema IN ( 'db_name' );