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

Posted in mysql | Tagged , , , , | Leave a comment

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

Posted in mysql | Tagged , , | Leave a comment

mysql_error() not displaying error

ShareError: mysql_error() not displaying error, Solution: possible cause is if u got 2 connections, u must supply the connection ur using

Posted in mysql | Tagged , , , | Leave a comment

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 , , , , , | 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 , , , , , | Leave a comment