tworzenieweb/clean.sh

Created February 14, 2017 21:21

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/tworzenieweb/570f3e2a6acbdd6524a4bc2725a9cc33.js"></script>
Save tworzenieweb/570f3e2a6acbdd6524a4bc2725a9cc33 to your computer and use it in GitHub Desktop.

Download ZIP

Remove _test_ tables from mysql schemas

Raw

mysql -u root -se "SELECT CONCAT('DROP DATABASE ', SCHEMA_NAME, ';') FROM information_schema.SCHEMATA WHERE SCHEMA_NAME LIKE '%_test_%'"

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