码间练习 👋🏼

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;