If you have a table of GPS data ,that keeps getting written to, and starts to run to millions of records. It is a sensible idea to create a trigger under mysql to update a scratchpad summary table on an … Continued
MySQL Master Slave – Replication
If you need to run mysql replication, then we can help configue it for you, its a fantastic way of allowing you to run reporting against a large dataset, by running all your queries against the slave database, and this … Continued
Ritchie Hunter Website Live
Congrats to Ryan on completing the new ritchiehunter.com site, its a wordpress site that is using media queries to enable it to be viewed sensibly on various different display resolutions. Its using responsive design patterns and is built in … Continued
Using Sum and ABS statements in MySQL
MySQL / PHP Problem I need to sum the number of entries in a table where an id > 0 or an id = 23 Resolution Use a GROUP BY clause in conjunction with a SUM and an ABS SUM( … Continued