title: How to empty all rows from all tables in mysql (in sql)
body: <p>I'm writing some db utility scripts, and one of the tasks I need to do is rebuild the data only, but leave the schema intact. What is the easiest way to automate this from the command-line using bash and the mysql tools (no php, etc)?</p>
  
  <p>Update:
  I'd like the solution to handle all tables in one command, and if possible, not need to be updated if tables are added or removed.</p>