DEV Community

sunj
sunj

Posted on

Sql, table 모두 삭제

#sql #mysql 
SELECT Concat('DROP TABLE ', table_schema, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES where table_schema = '데이터베이스이름';
Enter fullscreen mode Exit fullscreen mode 
foreign_key 무시
set foreign_key_checks = 0;
Enter fullscreen mode Exit fullscreen mode

참조 : https://velog.io/@cykim/MySQL-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%A0%84%EC%B2%B4-%EC%82%AD%EC%A0%9C_

Top comments (0)

Read next

trixsec profile image

List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

Trix Cyrus -

leandro_nnz profile image

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Leandro Nuñez -

mrcaption49 profile image

RANK,ROW_NUMBER and DENSE_RANK

Pranav Bakare -

trixsec profile image

SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

Trix Cyrus -