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为数据库名
2021-10-11 01:20:03
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为数据库名
下一篇:oracle 锁表