Crawl Log: September 2008

Monday, September 29, 2008

Original Post from: WebAddictos.com

1. Using IF
http://www.experts-exchange.com/Database/MySQL/Q_20522525.html

mysql> SELECT (if(answer=1,1,0))yes,
sum(if(answer='2','1','0')) no,
sum(if(answer=0,1,0))don_t_care
FROM favicon_poll;
+------+------+------------+
yes no don_t_care
+------+------+------------+
3 13 2
+------+------+------------+
1 row in set (0.00 sec)

2. Using CASE
Conversion of Oracle Decode to MySQL Case
http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-041.html

mysql> select CASE answer when 1 THEN 'yes' when 2 THEN 'no' else 'unknown' end from favicon_poll;

More information--------------------------------------------------------
mysql elt() and field() functions
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_elts

Oracle Decode and CASE

MySQL equivalent to Oracle Decode
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_elt

Expert Exchange Article
http://www.experts-exchange.com/Database/MySQL/Q_20522525.html

Parsing HTML Content
http://www.onderstekop.nl/articles/114/

Class: HTML SQL - extract html as sql
http://www.phpclasses.org/browse/package/3086.html

mingus 0.3 - the music theory package for Python
http://code.google.com/p/mingus/

Hydrogen - http://www.hydrogen-music.org/
info: Hydrogen is an advanced drum machine for GNU/Linux, although there also appears to be a Windows installer available
article: http://www.onderstekop.nl/articles/118/