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 more
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 more
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
If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…
Read more
In a typical MySQL installation, the default character set and collation are latin1 and latin1_swedish_ci. This means that all string comparisons will be performed in a case insensitive manner. So, ‘Search String’=’search string’. This…
Read more
These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…
Read more