Select CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables where table_schema='sql856243'

得出
drop table dede_addonarticle;
drop table dede_addonimages;
drop table dede_addoninfos;
drop table dede_addonshop;
drop table dede_addonsoft;
drop table dede_addonspec;
drop table dede_admin;
drop table dede_admintype;
drop table dede_advancedsearch;
drop table dede_arcatt;
drop table dede_arccache;
drop table dede_archives;
drop table dede_arcmulti;
drop table dede_arcrank;
drop table dede_arctiny;
drop table dede_arctype;
drop table dede_area;
drop table dede_channeltype;
drop table dede_co_htmls;
drop table dede_co_mediaurls;
drop table dede_co_note;
drop table dede_co_onepage;
drop table dede_co_urls;
drop table dede_diyform1;
drop table dede_diyforms;
drop table dede_dl_log;
drop table dede_downloads;
drop table dede_erradd;
drop table dede_feedback;
drop table dede_flink;
drop table dede_flinktype;
drop table dede_freelist;
drop table dede_homepageset;
drop table dede_keywords;
drop table dede_log;
drop table dede_member;
drop table dede_member_company;
drop table dede_member_feed;
drop table dede_member_flink;
drop table dede_member_friends;
drop table dede_member_group;
drop table dede_member_guestbook;
drop table dede_member_model;
drop table dede_member_msg;
drop table dede_member_operation;
drop table dede_member_person;
drop table dede_member_pms;
drop table dede_member_snsmsg;
drop table dede_member_space;
drop table dede_member_stow;
drop table dede_member_stowtype;
drop table dede_member_tj;
drop table dede_member_type;
drop table dede_member_vhistory;
drop table dede_moneycard_record;
drop table dede_moneycard_type;
drop table dede_mtypes;
drop table dede_multiserv_config;
drop table dede_myad;
drop table dede_myadtype;
drop table dede_mytag;
drop table dede_payment;
drop table dede_plus;
drop table dede_plus_mda_setting;
drop table dede_plus_seoinfo;
drop table dede_purview;
drop table dede_pwd_tmp;
drop table dede_ratings;
drop table dede_scores;
drop table dede_search_cache;
drop table dede_search_keywords;
drop table dede_sgpage;
drop table dede_shops_delivery;
drop table dede_shops_orders;
drop table dede_shops_products;
drop table dede_shops_userinfo;
drop table dede_softconfig;
drop table dede_sphinx;
drop table dede_stepselect;
drop table dede_sys_enum;
drop table dede_sys_module;
drop table dede_sys_set;
drop table dede_sys_task;
drop table dede_sysconfig;
drop table dede_tagindex;
drop table dede_taglist;
drop table dede_uploads;
drop table dede_verifies;
drop table dede_vote;
drop table dede_vote_member;

然后删除
Where table_name LIKE 'dede_%';

dede_指定前缀表

生成删表语句,然后执行这些语句

标签: admin

添加新评论