MySQL – 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 moreA 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 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 moreThere 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 moreHave 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 moreIf 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 moreIn 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