delete tab_drcu_circuit,tab_sys_accountinfo,tab_sys_flows,tab_sys_flows,tab_sys_flows from tab_drcu_circuit,tab_sys_accountinfo,tab_sys_flows,tab_sys_flows,tab_sys_flows;
呵呵,没有,用SP来完成,取得所有表名,循环SET @SQL=CONCAT('DELETE FROM ',TABLENAME) PREPARE EE FROM @SQL EXECUTE EE
哦,看错了。 如果是要留下这五个表。则没什么好办法。只能通过 SELECT TABLE_NAME FROM information_schema.TABLES where TABLE_SCHEMA='db_neuplatform' and TABLE_TYPE='BASE TABLE' and TABLE_NAME not in ('tab_drcu_circuit','tab_sys_accountinfo','tab_sys_flows','tab_sys_flows','tab_sys_flows')得到所有表名,然后利用存储过程,全部删除
PREPARE EE FROM @SQL
EXECUTE EE
SELECT TABLE_NAME FROM information_schema.TABLES
where TABLE_SCHEMA='db_neuplatform'
and TABLE_TYPE='BASE TABLE'
and TABLE_NAME not in ('tab_drcu_circuit','tab_sys_accountinfo','tab_sys_flows','tab_sys_flows','tab_sys_flows')得到所有表名,然后利用存储过程,全部删除