Home  >  Article  >  Database  >  [MySQL] TRUNCATE整个库前,打印所有TRUNCATE表语句

[MySQL] TRUNCATE整个库前,打印所有TRUNCATE表语句

WBOY
WBOYOriginal
2016-06-07 14:57:111329browse

无详细内容 无 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