tusharvikky/drop.sql

Last active June 28, 2016 07:45

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tusharvikky/cd90d552011c6801721a7ddbb8e9b4e2.js"></script>
Save tusharvikky/cd90d552011c6801721a7ddbb8e9b4e2 to your computer and use it in GitHub Desktop.

Download ZIP

Drop all tables of a DB

Raw

mysql -u<db_username> -p<db_password> -Nse 'show tables' <db_name> | while read table; do echo "SET FOREIGN_KEY_CHECKS = 0; drop table $table;"; done | mysql -u<db_username> -p<db_password> <db_name>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment