Custom ordering by a list of values

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 ids . . . → Read More: Custom ordering by a list of values

Very simple database structure for a tag cloud

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 will . . . → Read More: Very simple database structure for a tag cloud

Types of functions in MySQL

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 aggregate . . . → Read More: Types of functions in MySQL

Categories

Archives

Calendar

October 2017
M T W T F S S
« Jul    
 1
2345678
9101112131415
16171819202122
23242526272829
3031