Example: Let's say table A has two children B and C. Then we can use the following syntax to drop all tables.DROP TABLE IF EXISTS B,C,A; drop table user_flinktype,....;或者 从information_schema; 数据库中的tables 表中select 出你要 删除的表的名字 select table_name from information_schema.tables where table_name like ' _%';然后以逗号分割(tablenames)drop table tablenames;
表,然后选择删除就可以了!
下载地址:http://dev.mysql.com/downloads/administrator/1.1.html
Let's say table A has two children B and C. Then we can use the following syntax to drop all tables.DROP TABLE IF EXISTS B,C,A;
drop table user_flinktype,....;或者
从information_schema; 数据库中的tables 表中select 出你要
删除的表的名字
select table_name from information_schema.tables where table_name like '
_%';然后以逗号分割(tablenames)drop table tablenames;