SELECT
	CONCAT( 'TRUNCATE table  ', table_name, ';' ) 
FROM
	information_schema.`TABLES` 
WHERE
	table_schema = 'schema' 
	AND table_name LIKE 'teacher_%';

查询数据表大小

SELECT 
    table_name AS 'Table',
    round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size in MB'
FROM information_schema.TABLES
WHERE 
    table_schema = 'zhxy  -- 替换为你的数据库名
ORDER BY (data_length + index_length) DESC;