sebastian-s2
4/8/2014 - 10:06 PM

Drop all tables in a MySQL DB

Drop all tables in a MySQL DB

gistfile1.txt
content_copyfile_download
# You can thank https://twitter.com/miguel2angel

mysql -N -e "SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name), ';') FROM information_schema.tables WHERE table_schema = 'dbName'" | mysql dbName