Skip to content

Instantly share code, notes, and snippets.

@sergeycherepanov

sergeycherepanov/delete mysql tables by mask

Created December 8, 2015 22:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sergeycherepanov/8e75b67d209e053512b4 to your computer and use it in GitHub Desktop.
Save sergeycherepanov/8e75b67d209e053512b4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
delete mysql tables by mask
mysql -uroot -proot pradam_new -e "show tables" | grep ^customer_ | awk '{print "delete from "$0";"}' | mysql -uroot -proot pradam_new
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment