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
Tag Archives: mysql
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
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
Which is best for monetary data: double, float, decimal
ShareFor floating-point data types, MySQL uses four bytes for single-precision values and eight bytes for double-precision values. The FLOAT and DOUBLE data types are used to represent approximate numeric data values. For FLOAT the SQL standard allows an optional specification … Continue reading
Posted in mysql
Tagged decimal, double, float, floating point data types, monetaray data type, mysql
Leave a comment
Installing apache 2.2, php 5.2 and mysql 5 in windows vista
ShareHere’s a quick guide for installing apache 2.2, php 5.2 and mysql 5 in windows vista. Download needed files: 1. Apache – msi file 2. PHP – better choose the zip file than the msi installer 3. MYSQL – msi … Continue reading
Posted in apache, mysql, php
Tagged error installing apache mysql php, httpd.conf, installing apache, mysql, php, php.ini
Leave a comment