A common thing you need to do in mysql is add an interval of time to a date in a query. Here is a simple example of how to do this:
SELECT Risk.*
FROM Risk
WHERE (Risk.Next_Reminder_Due IS NULL OR
Risk.Next_Reminder_Due < DATE_ADD(NOW(), INTERVAL 7 DAY))
This returns all ‘risks’ that either have [...]
This is really simple - and quite useful if you are trying to insert a date into mysql and you can’t use the “now()” mysql command (due to say a timezone difference):
$date = date(”Y-m-d G:i:s”);
Recently we’ve been having some problems with our production server. Every now and then it just reboots - for no aparent reason. We’re still looking into the reason this occurs (looks like an overheating CPU) however when the reboot occurs, it causes our Mysql replication slaves to get out-of-sync with the master.
The following is a simple guide to help you setup Mysql replication - a fantastic way to ensure you have an up-to-date backup of your production databases.
This guide only describes a single master-slave relationship, however you can use mysql in various modes which include additional slaves as required.
I’ve modified my CSV to SQL conversion tool (csv2sql.com) so that it now can produce both INSERT and UPDATE SQL statements from your CSV file. Previously the tool only created INSERT statements, so you could easily insert all your CSV data into your database table.
However this is rather limited - what if you want to later [...]
Recently I upgraded to a new Mac. I like to install applications from scratch when I upgrade, as it allows me to clean out all the garbage that I didn’t need in the first place. So I’ve compiled a list of all the best free applications I like to have installed on my [...]