mysql drop 同一前缀得所有表

admin · 发表于 2020-6-14 21:54:05

SELECT concat('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_name like 'ixinji%';
+------------------------------------------------------------+
| concat('DROP TABLE IF EXISTS ', table_name, ';') |
+------------------------------------------------------------+
| DROP TABLE IF EXISTS ixinji_common_admincp_cmenu; |
| DROP TABLE IF EXISTS ixinji_common_admincp_group; |
| DROP TABLE IF EXISTS ixinji_common_admincp_member; |
| DROP TABLE IF EXISTS ixinji_common_admincp_perm; |
| DROP TABLE IF EXISTS ixinji_common_admincp_session; |
| DROP TABLE IF EXISTS ixinji_common_admingroup; |
| DROP TABLE IF EXISTS ixinji_common_adminnote; |
| DROP TABLE IF EXISTS ixinji_common_advertisement; |
| DROP TABLE IF EXISTS ixinji_common_advertisement_custom; |
| DROP TABLE IF EXISTS ixinji_common_banned; |
| DROP TABLE IF EXISTS ixinji_common_block; |
| DROP TABLE IF EXISTS ixinji_common_block_favorite; |
| DROP TABLE IF EXISTS ixinji_common_block_item; |
| DROP TABLE IF EXISTS ixinji_common_block_item_data; |
| DROP TABLE IF EXISTS ixinji_common_block_permission; |
| DROP TABLE IF EXISTS ixinji_common_block_pic; |
| DROP TABLE IF EXISTS ixinji_common_block_style; |
| DROP TABLE IF EXISTS ixinji_common_block_xml; |
| DROP TABLE IF EXISTS ixinji_common_cache; |
| DROP TABLE IF EXISTS ixinji_common_card; |
| DROP TABLE IF EXISTS ixinji_common_card_log; |
| DROP TABLE IF EXISTS ixinji_common_card_type; |
| DROP TABLE IF EXISTS ixinji_common_connect_guest; |
| DROP TABLE IF EXISTS ixinji_common_credit_log; |
| DROP TABLE IF EXISTS ixinji_common_credit_log_field; |
| DROP TABLE IF EXISTS ixinji_common_credit_rule; |
| DROP TABLE IF EXISTS ixinji_common_credit_rule_log; |
| DROP TABLE IF EXISTS ixinji_common_credit_rule_log_field; |
| DROP TABLE IF EXISTS ixinji_common_cron; |
| DROP TABLE IF EXISTS ixinji_common_devicetoken; |
| DROP TABLE IF EXISTS ixinji_common_district; |
| DROP TABLE IF EXISTS ixinji_common_diy_data; |
| DROP TABLE IF EXISTS ixinji_common_domain; |
| DROP TABLE IF EXISTS ixinji_common_failedip; |
| DROP TABLE IF EXISTS ixinji_common_failedlogin; |
| DROP TABLE IF EXISTS ixinji_common_friendlink; |
| DROP TABLE IF EXISTS ixinji_common_grouppm; |
| DROP TABLE IF EXISTS ixinji_common_invite; |
| DROP TABLE IF EXISTS ixinji_common_magic; |
| DROP TABLE IF EXISTS ixinji_common_magiclog; |
| DROP TABLE IF EXISTS ixinji_common_mailcron; |
| DROP TABLE IF EXISTS ixinji_common_mailqueue; |
| DROP TABLE IF EXISTS ixinji_common_member; |
| DROP TABLE IF EXISTS ixinji_common_member_action_log; |
| DROP TABLE IF EXISTS ixinji_common_member_connect; |
| DROP TABLE IF EXISTS ixinji_common_member_count; |
| DROP TABLE IF EXISTS ixinji_common_member_crime; |
| DROP TABLE IF EXISTS ixinji_common_member_field_forum; |
| DROP TABLE IF EXISTS ixinji_common_member_field_home; |
| DROP TABLE IF EXISTS ixinji_common_member_forum_buylog; |
| DROP TABLE IF EXISTS ixinji_common_member_grouppm; |
| DROP TABLE IF EXISTS ixinji_common_member_log; |
| DROP TABLE IF EXISTS ixinji_common_member_magic; |
| DROP TABLE IF EXISTS ixinji_common_member_medal; |
| DROP TABLE IF EXISTS ixinji_common_member_newprompt; |
| DROP TABLE IF EXISTS ixinji_common_member_profile; |
| DROP TABLE IF EXISTS ixinji_common_member_profile_setting; |
| DROP TABLE IF EXISTS ixinji_common_member_security; |
| DROP TABLE IF EXISTS ixinji_common_member_secwhite; |
| DROP TABLE IF EXISTS ixinji_common_member_stat_field; |
| DROP TABLE IF EXISTS ixinji_common_member_status; |
| DROP TABLE IF EXISTS ixinji_common_member_validate; |
| DROP TABLE IF EXISTS ixinji_common_member_verify; |
| DROP TABLE IF EXISTS ixinji_common_member_verify_info; |
| DROP TABLE IF EXISTS ixinji_common_myapp; |
| DROP TABLE IF EXISTS ixinji_common_myinvite; |
| DROP TABLE IF EXISTS ixinji_common_mytask; |
| DROP TABLE IF EXISTS ixinji_common_nav; |
| DROP TABLE IF EXISTS ixinji_common_onlinetime; |
| DROP TABLE IF EXISTS ixinji_common_optimizer; |
| DROP TABLE IF EXISTS ixinji_common_patch; |
| DROP TABLE IF EXISTS ixinji_common_plugin; |
| DROP TABLE IF EXISTS ixinji_common_pluginvar; |
| DROP TABLE IF EXISTS ixinji_common_process; |
| DROP TABLE IF EXISTS ixinji_common_regip; |
| DROP TABLE IF EXISTS ixinji_common_relatedlink; |
| DROP TABLE IF EXISTS ixinji_common_remote_port; |
| DROP TABLE IF EXISTS ixinji_common_report; |
| DROP TABLE IF EXISTS ixinji_common_searchindex; |
| DROP TABLE IF EXISTS ixinji_common_seccheck; |
| DROP TABLE IF EXISTS ixinji_common_secquestion; |
| DROP TABLE IF EXISTS ixinji_common_session; |
| DROP TABLE IF EXISTS ixinji_common_setting; |
| DROP TABLE IF EXISTS ixinji_common_smiley; |
| DROP TABLE IF EXISTS ixinji_common_sphinxcounter; |
| DROP TABLE IF EXISTS ixinji_common_stat; |
| DROP TABLE IF EXISTS ixinji_common_statuser; |
| DROP TABLE IF EXISTS ixinji_common_style; |
| DROP TABLE IF EXISTS ixinji_common_stylevar; |
| DROP TABLE IF EXISTS ixinji_common_syscache; |
| DROP TABLE IF EXISTS ixinji_common_tag; |
| DROP TABLE IF EXISTS ixinji_common_tagitem; |
| DROP TABLE IF EXISTS ixinji_common_task; |
| DROP TABLE IF EXISTS ixinji_common_taskvar; |
| DROP TABLE IF EXISTS ixinji_common_template; |
| DROP TABLE IF EXISTS ixinji_common_template_block; |
| DROP TABLE IF EXISTS ixinji_common_template_permission; |
| DROP TABLE IF EXISTS ixinji_common_uin_black; |
| DROP TABLE IF EXISTS ixinji_common_usergroup; |
| DROP TABLE IF EXISTS ixinji_common_usergroup_field; |
| DROP TABLE IF EXISTS ixinji_common_visit; |
| DROP TABLE IF EXISTS ixinji_common_word; |
| DROP TABLE IF EXISTS ixinji_common_word_type; |
| DROP TABLE IF EXISTS ixinji_connect_disktask; |
| DROP TABLE IF EXISTS ixinji_connect_feedlog; |
| DROP TABLE IF EXISTS ixinji_connect_memberbindlog; |
| DROP TABLE IF EXISTS ixinji_connect_postfeedlog; |
| DROP TABLE IF EXISTS ixinji_connect_tthreadlog; |
| DROP TABLE IF EXISTS ixinji_forum_access; |
| DROP TABLE IF EXISTS ixinji_forum_activity; |
| DROP TABLE IF EXISTS ixinji_forum_activityapply; |
| DROP TABLE IF EXISTS ixinji_forum_announcement; |
| DROP TABLE IF EXISTS ixinji_forum_attachment; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_0; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_1; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_2; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_3; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_4; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_5; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_6; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_7; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_8; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_9; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_exif; |
| DROP TABLE IF EXISTS ixinji_forum_attachment_unused; |
| DROP TABLE IF EXISTS ixinji_forum_attachtype; |
| DROP TABLE IF EXISTS ixinji_forum_bbcode; |
| DROP TABLE IF EXISTS ixinji_forum_collection; |
| DROP TABLE IF EXISTS ixinji_forum_collectioncomment; |
| DROP TABLE IF EXISTS ixinji_forum_collectionfollow; |
| DROP TABLE IF EXISTS ixinji_forum_collectioninvite; |
| DROP TABLE IF EXISTS ixinji_forum_collectionrelated; |
| DROP TABLE IF EXISTS ixinji_forum_collectionteamworker; |
| DROP TABLE IF EXISTS ixinji_forum_collectionthread; |
| DROP TABLE IF EXISTS ixinji_forum_creditslog; |
| DROP TABLE IF EXISTS ixinji_forum_debate; |
| DROP TABLE IF EXISTS ixinji_forum_debatepost; |
| DROP TABLE IF EXISTS ixinji_forum_faq; |
| DROP TABLE IF EXISTS ixinji_forum_filter_post; |
| DROP TABLE IF EXISTS ixinji_forum_forum; |
| DROP TABLE IF EXISTS ixinji_forum_forum_threadtable; |
| DROP TABLE IF EXISTS ixinji_forum_forumfield; |
| DROP TABLE IF EXISTS ixinji_forum_forumrecommend; |
| DROP TABLE IF EXISTS ixinji_forum_groupcreditslog; |
| DROP TABLE IF EXISTS ixinji_forum_groupfield; |
| DROP TABLE IF EXISTS ixinji_forum_groupinvite; |
| DROP TABLE IF EXISTS ixinji_forum_grouplevel; |
| DROP TABLE IF EXISTS ixinji_forum_groupuser; |
| DROP TABLE IF EXISTS ixinji_forum_hotreply_member; |
| DROP TABLE IF EXISTS ixinji_forum_hotreply_number; |
| DROP TABLE IF EXISTS ixinji_forum_imagetype; |
| DROP TABLE IF EXISTS ixinji_forum_medal; |
| DROP TABLE IF EXISTS ixinji_forum_medallog; |
| DROP TABLE IF EXISTS ixinji_forum_memberrecommend; |
| DROP TABLE IF EXISTS ixinji_forum_moderator; |
| DROP TABLE IF EXISTS ixinji_forum_modwork; |
| DROP TABLE IF EXISTS ixinji_forum_newthread; |
| DROP TABLE IF EXISTS ixinji_forum_onlinelist; |
| DROP TABLE IF EXISTS ixinji_forum_order; |
| DROP TABLE IF EXISTS ixinji_forum_poll; |
| DROP TABLE IF EXISTS ixinji_forum_polloption; |
| DROP TABLE IF EXISTS ixinji_forum_polloption_image; |
| DROP TABLE IF EXISTS ixinji_forum_pollvoter; |
| DROP TABLE IF EXISTS ixinji_forum_post; |
| DROP TABLE IF EXISTS ixinji_forum_post_location; |
| DROP TABLE IF EXISTS ixinji_forum_post_moderate; |
| DROP TABLE IF EXISTS ixinji_forum_post_tableid; |
| DROP TABLE IF EXISTS ixinji_forum_postcache; |
| DROP TABLE IF EXISTS ixinji_forum_postcomment; |
| DROP TABLE IF EXISTS ixinji_forum_postlog; |
| DROP TABLE IF EXISTS ixinji_forum_poststick; |
| DROP TABLE IF EXISTS ixinji_forum_promotion; |
| DROP TABLE IF EXISTS ixinji_forum_ratelog; |
| DROP TABLE IF EXISTS ixinji_forum_relatedthread; |
| DROP TABLE IF EXISTS ixinji_forum_replycredit; |
| DROP TABLE IF EXISTS ixinji_forum_rsscache; |
| DROP TABLE IF EXISTS ixinji_forum_sofa; |
| DROP TABLE IF EXISTS ixinji_forum_spacecache; |
| DROP TABLE IF EXISTS ixinji_forum_statlog; |
| DROP TABLE IF EXISTS ixinji_forum_thread; |
| DROP TABLE IF EXISTS ixinji_forum_thread_moderate; |
| DROP TABLE IF EXISTS ixinji_forum_threadaddviews; |
| DROP TABLE IF EXISTS ixinji_forum_threadcalendar; |
| DROP TABLE IF EXISTS ixinji_forum_threadclass; |
| DROP TABLE IF EXISTS ixinji_forum_threadclosed; |
| DROP TABLE IF EXISTS ixinji_forum_threaddisablepos; |
| DROP TABLE IF EXISTS ixinji_forum_threadhidelog; |
| DROP TABLE IF EXISTS ixinji_forum_threadhot; |
| DROP TABLE IF EXISTS ixinji_forum_threadimage; |
| DROP TABLE IF EXISTS ixinji_forum_threadlog; |
| DROP TABLE IF EXISTS ixinji_forum_threadmod; |
| DROP TABLE IF EXISTS ixinji_forum_threadpartake; |
| DROP TABLE IF EXISTS ixinji_forum_threadpreview; |
| DROP TABLE IF EXISTS ixinji_forum_threadprofile; |
| DROP TABLE IF EXISTS ixinji_forum_threadprofile_group; |
| DROP TABLE IF EXISTS ixinji_forum_threadrush; |
| DROP TABLE IF EXISTS ixinji_forum_threadtype; |
| DROP TABLE IF EXISTS ixinji_forum_trade; |
| DROP TABLE IF EXISTS ixinji_forum_tradecomment; |
| DROP TABLE IF EXISTS ixinji_forum_tradelog; |
| DROP TABLE IF EXISTS ixinji_forum_typeoption; |
| DROP TABLE IF EXISTS ixinji_forum_typeoptionvar; |
| DROP TABLE IF EXISTS ixinji_forum_typevar; |
| DROP TABLE IF EXISTS ixinji_forum_warning; |
| DROP TABLE IF EXISTS ixinji_home_album; |
| DROP TABLE IF EXISTS ixinji_home_album_category; |
| DROP TABLE IF EXISTS ixinji_home_appcreditlog; |
| DROP TABLE IF EXISTS ixinji_home_blacklist; |
| DROP TABLE IF EXISTS ixinji_home_blog; |
| DROP TABLE IF EXISTS ixinji_home_blog_category; |
| DROP TABLE IF EXISTS ixinji_home_blog_moderate; |
| DROP TABLE IF EXISTS ixinji_home_blogfield; |
| DROP TABLE IF EXISTS ixinji_home_class; |
| DROP TABLE IF EXISTS ixinji_home_click; |
| DROP TABLE IF EXISTS ixinji_home_clickuser; |
| DROP TABLE IF EXISTS ixinji_home_comment; |
| DROP TABLE IF EXISTS ixinji_home_comment_moderate; |
| DROP TABLE IF EXISTS ixinji_home_docomment; |
| DROP TABLE IF EXISTS ixinji_home_doing; |
| DROP TABLE IF EXISTS ixinji_home_doing_moderate; |
| DROP TABLE IF EXISTS ixinji_home_favorite; |
| DROP TABLE IF EXISTS ixinji_home_feed; |
| DROP TABLE IF EXISTS ixinji_home_feed_app; |
| DROP TABLE IF EXISTS ixinji_home_follow; |
| DROP TABLE IF EXISTS ixinji_home_follow_feed; |
| DROP TABLE IF EXISTS ixinji_home_follow_feed_archiver; |
| DROP TABLE IF EXISTS ixinji_home_friend; |
| DROP TABLE IF EXISTS ixinji_home_friend_request; |
| DROP TABLE IF EXISTS ixinji_home_friendlog; |
| DROP TABLE IF EXISTS ixinji_home_notification; |
| DROP TABLE IF EXISTS ixinji_home_pic; |
| DROP TABLE IF EXISTS ixinji_home_pic_moderate; |
| DROP TABLE IF EXISTS ixinji_home_picfield; |
| DROP TABLE IF EXISTS ixinji_home_poke; |
| DROP TABLE IF EXISTS ixinji_home_pokearchive; |
| DROP TABLE IF EXISTS ixinji_home_share; |
| DROP TABLE IF EXISTS ixinji_home_share_moderate; |
| DROP TABLE IF EXISTS ixinji_home_show; |
| DROP TABLE IF EXISTS ixinji_home_specialuser; |
| DROP TABLE IF EXISTS ixinji_home_userapp; |
| DROP TABLE IF EXISTS ixinji_home_userappfield; |
| DROP TABLE IF EXISTS ixinji_home_visitor; |
| DROP TABLE IF EXISTS ixinji_mobile_setting; |
| DROP TABLE IF EXISTS ixinji_mobile_wsq_threadlist; |
| DROP TABLE IF EXISTS ixinji_portal_article_content; |
| DROP TABLE IF EXISTS ixinji_portal_article_count; |
| DROP TABLE IF EXISTS ixinji_portal_article_moderate; |
| DROP TABLE IF EXISTS ixinji_portal_article_related; |
| DROP TABLE IF EXISTS ixinji_portal_article_title; |
| DROP TABLE IF EXISTS ixinji_portal_article_trash; |
| DROP TABLE IF EXISTS ixinji_portal_attachment; |
| DROP TABLE IF EXISTS ixinji_portal_category; |
| DROP TABLE IF EXISTS ixinji_portal_category_permission; |
| DROP TABLE IF EXISTS ixinji_portal_comment; |
| DROP TABLE IF EXISTS ixinji_portal_comment_moderate; |
| DROP TABLE IF EXISTS ixinji_portal_rsscache; |
| DROP TABLE IF EXISTS ixinji_portal_topic; |
| DROP TABLE IF EXISTS ixinji_portal_topic_pic; |
| DROP TABLE IF EXISTS ixinji_security_evilpost; |
| DROP TABLE IF EXISTS ixinji_security_eviluser; |
| DROP TABLE IF EXISTS ixinji_security_failedlog; |
+------------------------------------------------------------+
261 rows in set (0.05 sec)

复制代码

		自动登录	找回密码
密码			立即注册