MySQL – ORDER BY does not sort data properly…
Imagine a developer working late at night trying to complete some simple queries for a report due the next day. No matter what she does, the resulting query will just…
Read moreMySQL – 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 – Help, I lost the Root password! Error number 1045
Have you ever seen the dreaded MySQL Error number 1045 Access denied for user ‘root’@’localhost’ (using password: YES)? Don’t worry, this is an easy to recover from situation. Just follow…
Read more