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

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

WBOY
Release: 2016-06-07 14:57:11
Original
1344 people have browsed it

无详细内容 无 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'
Copy after login
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template