HomeAboutMeBlogGuest
© 2025 Sejin Cha. All rights reserved.
Built with Next.js, deployed on Vercel
🏩
Mysql 테이블 전체 삭제
🏩

Mysql 테이블 전체 삭제

작성자
태그
Setting
속성
Aug 7, 2022 01:45 AM
SET @tables = NULL; SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables FROM information_schema.tables WHERE table_schema = 'timedealdb'; SET @tables = CONCAT('DROP TABLE', @tables); PREPARE stmt FROM @tables; EXECUTE stmt; DEALLOCATE PREPARE stmt;