数据库维护,表维护常常用到。疑难编程联系我QQ467477957

Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE 'dede_%';
"dede"为要删除的表前缀,执行此SQL语句后会生成一串SQL语句,必须再执行生成的这些SQL语句才能真正执行删除操作。
Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE 'dede_%';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_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_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;

评论() 相关

收藏

赞

zjj4131

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。