Truncate all tables in a MySQL database in one command?

by

Drop (i.e. remove tables)

mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "drop table $table" DATABASE_NAME; done

Truncate (i.e. empty tables)

mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done

More Related Contents:

  1. Equivalent of explode() to work with strings in MySQL
  2. How can I tell when a MySQL table was last updated?
  3. UTF-8: General? Bin? Unicode?
  4. Transposing Dynamic Columns to Rows
  5. Run MySQLDump without Locking Tables
  6. count(*) and count(column_name), what’s the diff?
  7. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  8. When to use SELECT … FOR UPDATE?
  9. MySQL Select Date Equal to Today (having datetime as the data type)
  10. BULK INSERT in MYSQL
  11. Setting column values as column names in the SQL query result
  12. Count table rows
  13. MYSQL sum() for distinct rows
  14. How to deploy local MySQL database to Heroku
  15. How to lock a single row
  16. MySQL Cannot drop index needed in a foreign key constraint
  17. Laravel join with 3 Tables
  18. MySQL Insert & Joins
  19. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  20. How to join two tables using a comma-separated-list in the join field
  21. Does MySQL included with MAMP not include a config file?
  22. How to regex in a MySQL query
  23. How to remove duplicate entries from a mysql db?
  24. How do I write an SP in phpMyAdmin (MySQL)?
  25. Syntax error on MERGE statement
  26. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  27. What is the MAX number if I store int(255) in MySQL?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment