Building histograms using only MySQL
November 9th, 2009
The query means a very simple thing: select count of matching rows, value of locations – grouped by locations field; rpad does all the magic – it basically says to add a certain number of ‘*’ on the right of empty string, number of ‘*’ is count(*). It’s been divided by 15 to fit the bar into the console screen. That’s it, chaps!
Posted in: Uncategorized
Leave a comment