mysql删除表数据保留表结构_mysql 删除(清除)所有表数据方法,表格保留

首先把删除表格的sql找出来:

SELECT CONCAT('TRUNCATE TABLE ',TABLE_NAME,';') FROM TABLES WHERE TABLE_SCHEMA='要删除DB名字'

结果大概:

TRUNCATE TABLE chat_activity;

TRUNCATE TABLE chat_checkin;

TRUNCATE TABLE chat_loginlog;

TRUNCATE TABLE chat_message;

TRUNCATE TABLE chat_message_bakup;

TRUNCATE TABLE chat_setting;

TRUNCATE TABLE chat_teacher;

TRUNCATE TABLE chat_tvote;

TRUNCATE TABLE chat_user;

TRUNCATE TABLE count_voting;

TRUNCATE TABLE cr_userinfo;

TRUNCATE TABLE diy_block;

TRUNCATE TABLE diy_color;

TRUNCATE TABLE diy_common;

TRUNCATE TABLE diy_kefu;

TRUNCATE TABLE diy_logo;

TRUNCATE TABLE diy_notice;

TRUNCATE TABLE diy_vipcode;

TRUNCATE TABLE user_type; 然后你懂的, 直接运行这个列表的sql就大功告成了!!!