I’m sure many of your are familiar with PHPMyAdmin. In short it’s a nice frontend to MySQL written in PHP that enables you to visually manipulate your MySQL databases and underlying data. The reason I mention PHPMyAdmin is I recently needed to add a similar feature of PHPMyAdmin into one of my applications. The feature being: generate an SQL query…
Tag: MySQL
MySQL query returning truncated results could be because of group_concat
I recently encountered an issue where my MySQL query was returning truncated results… and by truncated I mean it was returning only a fraction of the rows it should have been returning and the last of those rows was actually missing data. The query in question uses a few LEFT OUTER JOIN(s) and the GROUP_CONCAT function to eliminate duplicate results…