mysql没有现成的工具可以实现批量删除相同前缀的表，所以我们可以通过构造语句来进行删除;



首先通过以下语句构造出要执行的删除语句



SELECT CONCAT( 'drop table ', table_name, ';' ) 

FROM information_schema.tables 

WHERE tablename LIKE 'ot%';





CONCAT( 'drop table ', table_name, ';' )

drop table ot_ad;

drop table ot_banner;

drop table ot_collhistory;

drop table ot_collitem;

drop table ot_collresult;

drop table ot_colltype;

drop table ot_dbbak;

drop table ot_dberr;

drop table ot_filedata;

drop table ot_filever;

drop table ot_info;

drop table ot_infocontent1;

drop table ot_infomessage;

drop table ot_infomove;

drop table ot_infosys;

drop table ot_infotype;

drop table ot_infoweb;

drop table ot_keyword;

drop table ot_makediy;

drop table ot_member;

drop table ot_membergroup;

drop table ot_memberlog;

drop table ot_memberonline;

drop table ot_menufile;

drop table ot_menutree;

drop table ot_message;

drop table ot_paysoft;

drop table ot_sysadmin;

drop table ot_sysimages;

drop table ot_system;

drop table ot_template;

drop table ot_tplsys;

drop table ot_type;

drop table ot_upfile;

drop table ot_userapi;

drop table ot_userfile;

drop table ot_usergroup;

drop table ot_userip;

drop table ot_userlevel;

drop table ot_useronline;

drop table ot_users;

drop table ot_userscore;

drop table ot_usersys;





然后复制该结果将该结果放入sql的可视化工具执行即可