MySQL - How to append to select statements

UNION [ALL] is the magic command;

At least 2 select commands are needed for a union.

select a as name from t1;

union all

select b as name from t2;

this will have a query result from both table 1 and 2 as a single result set.

Install LAMP server on Ubuntu in a single command

sudo apt-get install lamp-server^

Music Maps

So I have been on a rant to identify new bands and music to listen to within a spesific genre. This led to me search for ways of finding "related bands" of known bands to me.
Although services like youtube an last.fm can do this I wanted an interactive map and found the following:


http://audiomap.tuneglue.net/
http://www.music-map.com/
http://liveplasma.com/