[MySQL] TRUNCATE整个库前，打印所有TRUNCATE表语句
- WBOYOriginal
- 2016-06-07 14:57:111331browse
无详细内容 无 select CONCAT('TRUNCATE TABLE mydatabase.',TABLE_NAME,';') FROM information_schema.TABLES WHERE TABLE_SCHEMA='mydatabase'
select CONCAT('TRUNCATE TABLE mydatabase.',TABLE_NAME,';') FROM information_schema.TABLES WHERE TABLE_SCHEMA='mydatabase'
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SQL xp_cmdshellNext article：sql 数据库递归，一般在存在父级、子级联用的较多