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 moreMySQL – Select rows from a table when a field starts with a number
A common request is how to select records from a table when a specific field starts with a number. This request often is used when searching free-form text fields where…
Read moreExiting a MySQL Stored Procedure in the middle of the code
While 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 – Best way to remove all data from a table
There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…
Read moreMySQL Delimiters – Or why I hate stored procedures and Error Code : 1064 You have an error in your SQL syntax.
MySQL 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 moreHow to increase MySQL performance when loading a Dump File
In MYSQL, as well as most database engines, restoring a backup, or importing from an existing dump file can take a long time depending on the number of indexes and…
Read more