执行下面sql语句,将结果集复制出来,然后批量执行
SELECT CONCAT("truncate table ",a.table_name,";") FROM(select table_name from information_schema.tables where table_schema='数据库名称') as a WHERE a.table_name LIKE "aa%"
执行下面sql语句,将结果集复制出来,然后批量执行
SELECT CONCAT("truncate table ",a.table_name,";") FROM(select table_name from information_schema.tables where table_schema='数据库名称') as a WHERE a.table_name LIKE "aa%"