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.
Monday, 22 August 2011
MySQL - How to append to select statements
UNION [ALL] is the magic command;
At least 2 select commands are needed for a union.
this will have a query result from both table 1 and 2 as a single result set.
At least 2 select commands are needed for a union.
this will have a query result from both table 1 and 2 as a single result set.
Tuesday, 19 April 2011
Monday, 21 February 2011
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/
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/