select
concat('delete from ', TABLE_NAME, ';')
from (
select * from information_schema.tables where table_schema=database()
) as table1;
More than 3 years have passed since last update.
MySQL 全テーブル全レコード削除クエリ
Last updated at Posted at 2020-09-18
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme