Search
-
Categories
Tags
5.2 best php editor css debian error finger eleven google htaccess javascript javascript function life lifehouse linux love Lyrics mod_rewrite mysql mysql error mysql function nickelback nusphere nusphere phped nusphere phped 5.2 palawan palawan vacation paralyzer pdflib php4 pdflib php5 photoshop php phped php editor php error php function plugin regex regular expression regular expressions vacation vhcs video windows vista wordpress wordpress error wow
Monthly Archives: May 2009
monetary data: decimal vs. double
Share The DECIMAL and NUMERIC data types are used to store exact numeric data values. In MySQL, NUMERIC is implemented as DECIMAL. These types are used to store values for which it is important to preserve exact precision, for example … Continue reading
mysql error: 1005
Share ERROR 1005: Can’t create table (errno: 121) Help Solution: For some reasons this error appeared for the first time and caused my mysql to drop. But it only happens when clicking on a specific table. So I recreated the … Continue reading
url rewriting guide
ShareIntroduction to mod_rewrite The Apache module mod_rewrite is a killer one, i.e. it is a really sophisticated module which provides a powerful way to do URL manipulations. With it you can do nearly all types of URL manipulations you ever … Continue reading
ISNULL() in mysql
ShareSELECT * FROM table1 LEFT JOIN table2 ON table2 .folder_id = table1.id WHERE members_folders.mem_id=’1100′ AND ISNULL(table2.id) -get records from table1 that doesn’t have a record on table2 ISNULL() – Test whether the argument is NULL source: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_isnull