By Sid, on June 15th, 2010%
There are times when I needed the results returned from mysql returned in a specific order. An example would be when I have a list of ids for which I need the rest of the information from mysql (not doing a query for each of the ids) but preserving the order in which my . . . → Read More: Custom ordering by a list of values
By Mihaela, on June 11th, 2010%
The tag cloud (or word cloud) is a visual representation of the word content of a given text: in plain English it’s a listing of the words having different sizes, those used more frequently being larger and those less used being smaller. It started out as a buzzword but quickly become largely used. I . . . → Read More: Very simple database structure for a tag cloud
By Mihaela, on June 10th, 2010%
MySQL supports two very distinct type of functions: regular functions (some may also call them scalar functions) and aggregate functions which is often used in conjunction with GROUP BY statement (in fact a statement containing no GROUP BY clause is equivalent to grouping on all rows). The difference between the two types is that . . . → Read More: Types of functions in MySQL
Recent Comments