MySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreWant a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreWhile exiting a MySQL function is fairly straight-forward, simply use the RETURN keyword, exiting a Stored Procedure is not quite as obvious. There is no EXIT keyword, however you can…
Read moreMySQL 5.0+ gave DBA’s the ability to write stored procedures and functions. This is a great addition, and one that all “real” DB engines should provide. But, as many DBA…
Read more