select concat(‘delete from ‘,table_name,‘;‘) from information_schema.tables where table_schema=‘jd_project_sector_test1‘ and Table_type=‘BASE TABLE‘
其中jd_project_sector_test1为数据库名
mysql一键生成，删除所有表数据的SQL
原文：https://www.cnblogs.com/niuniu0108/p/13983735.html
