Posts tagged: sql

2 post(s)

[2012-12-04] Sorting in SQL

It's not completely uncommon to come across databases set to use collations and/or code pages where the ORDER BY clause won't sort as expected; e.g. Åke might be sorted before Carl. A quick fix to this is to use either the CAST()- or the CONVERT()-function on the text field you...

[2012-11-14] SQL Buddy, the unmaintained alternative

If you, as I, think that phpMyAdmin is a useful tool but unnecessarily complex in regards of installation and user experience, then SQL Buddy might be the alternative for you. SQL Buddy is a web based administration tool for MySQL written in PHP. This tool is simple to use, yet...