Mysql如何清空数据库的所有表数据
摘要:1.先查询出库中的所有表,“db”是数据库名称SELECT CONCAT('truncate table ',TABLE_NAME,';') AS a FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'db' ;2.得到所有表后,复制,粘贴,运...
阅读全文
posted @ 2015-11-30 12:28
posted @ 2015-11-30 12:28
posted @ 2015-11-16 11:59
posted @ 2015-11-11 16:09
posted @ 2015-11-09 12:20
posted @ 2015-11-04 14:09