Skip to content

Instantly share code, notes, and snippets.

@guillaumevoisin

guillaumevoisin/truncate_all_tables

Created October 16, 2014 09:19
Show Gist options
  • Save guillaumevoisin/eb744423859e14014f11 to your computer and use it in GitHub Desktop.
Save guillaumevoisin/eb744423859e14014f11 to your computer and use it in GitHub Desktop.
Download ZIP
Truncate all tables of a database
Raw
truncate_all_tables
mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment