cmerrick · October 20, 2015 02:50
diff --git a/truncate-db b/truncate-db
 #!/bin/bash

 DB=$1

 mysql -Ne "SELECT TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA='$1'" INFORMATION_SCHEMA | while read TABLE; do
  mysql -Ne "TRUNCATE \`$TABLE\`" $DB
 done
	#!/bin/bash

	DB=$1

	mysql -Ne "SELECT TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA='$1'" INFORMATION_SCHEMA \| while read TABLE; do
	mysql -Ne "TRUNCATE \`$TABLE\`" $DB
	done