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 … Continue reading MySQL: NULL to 0 or any other value

Advertisements

Install PHPUnit on windows


Install pear open command line put following commands pear channel-discover pear.phpunit.de pear channel-discover components.ez.no pear channel-discover pear.symfony-project.com pear update-channels pear clear-cache pear install --alldeps phpunit/PHPUnit