Mysql: Drop / Truncate all tables in a database.
I had a need today to maintain the database schema but clear the data itself.
Here’s the little command line snippet.
mysql -u -p -D -Nse 'show tables' | while read TABLE; do mysql -u -p -D -e "truncate table $TABLE"; done
Gareth
Related Posts |
---|
Mysql – extract data from large .sql dumps |
Mysql – turn off word wrap |
Mysql: Find a table by its name |