Install Eclipse PDT on Arch Linux

Eclipse PDT requires jre as prerequisite, so you need to first install jre. Install Jre see here how to install jre Get Eclipse PDT go to eclipse pdt site http://www.eclipse.org/pdt/ Download linux version 32/64 bit depending on your os extract eclispse and just click on the eclipse file it will now open editor enjoy 🙂

MySQL: NULL to 0 or any other value

Converting null to 0 or any other value in mysql COALESCE(colname,0) Returns the first non-NULL value in the list, or NULL if there are no non-NULL values. usage : SELECT COALESCE(colname, 0); SELECT COALESCE(NULL,1); how it works: Parameter can be a table column or a static value, if table column name is given it searches […]