Mail us : david@stylus.co.za

Category Archives: MySQL

06Nov/15

Image courtesy of stockimages at FreeDigitalPhotos.net

PHP pagination: LIMIT in MySQL vs. FIRST / SKIP in FireBird

06/11/2015MySQLFirebird, LIMIT, MySQL, pagination, SKIPfoxbeefly

I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if only the “S” were for “Standard”… I was busy writing scripts atRead More…

06Nov/15

Image courtesy of Gualberto107 at FreeDigitalPhotos.net

MySQL TRIGGER

06/11/2015MySQLHeidiSQL, MySQL, phpMyAdmin, TRIGGERfoxbeefly

I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could find were all to complex and I could not get any of themRead More…

05Nov/15

MySQL simplicity

05/11/2015MySQLMySQLfoxbeefly

I love the fact that the best solutions are almost always the simplest! I spend a lot of time sanitising data. I use Excel a lot of the time to perform mostRead More…

20Aug/15

Excel report using data from MySQL Stored Procedure

Restrict running of a MySQL Stored Procedure by time

20/08/2015MySQLMySQL, stored proc, VICIDIALfoxbeefly

I am creating an Excel Report that queries a MySQL database using an ODBC connection. The data is the returned result of a Stored Procedure which contains some pretty slow, resource intensiveRead More…

15May/15

Storing IP addresses in MySQL

15/05/2015MySQL$_SERVER['REMOTE_ADDR'], INET_ATON(), INET_NTOA(), MySQL, RemoteAddressfoxbeefly

I have always stored IP addresses as strings in VARCHAR fields in MySQL. I am currently reading “High Performance MySQL” (O’Reilly) and it mentions the advantages of storing IP addresses as integersRead More…

15Apr/15

Complex SQL query using SUM and GROUP BY

15/04/2015MySQLhire me, MySQLfoxbeefly

Got this question as part of a skills evaluation test. It requires a query to calculate summary-like data from tables in an order system type database. There is an orders table thatRead More…