dubgeiser/gist:2269368

Created March 31, 2012 22:58

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

Select an option

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

Download ZIP

Delete all tables in a MySQL database.

Raw

gistfile1.sh

echo 'show tables;' | mysql -uUSER -pPASSWORD DBNAME | sed '1d' | sed -E 's/^(.*)$/DROP TABLE IF EXISTS `\1`;/' | mysql -uUSER -pPASSWORD DBNAME

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