mysql一键生成，删除所有表数据的SQL

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为数据库名