Error 1104 (too many records)

. The problem is that this query used to work perfectly with previous versions of Mysql and that using SET OPTINION SQL_BIG_SELECTS=1 doesn't help : Does anyone have a clue ? Best Regards Andrea Forghieri Emmegi S.p.A. - Before posting

Re: WHERE clouse

All the test I've made shows that the first query is faster . I can't believe my eyes. Andrea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

help displaying results from a mysql query with php

Instead of echo htmlspecialchars( stripslashes($row[$i])); use echo htmlspecialchars( stripslashes($row[0])); In fact , if you increase $i you increase the column thus , in the first cycle you see col 0 , in the second col 1 for more information visit

Re: Need help installing PHP (Linux) with MySQL and Apache

added the following lines in httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php php FilesMatch \.php(\..+)?$ SetOutputFilter PHP /FilesMatch Have fun Andrea Forghieri - Before posting, please

Re: Mysql 4.0.4 + InnoDB leads to corrupted tables ?

grown orchards in there ;-) ). After restoring the AC, MySql and InnoDb are back to businness !! As far as I am concerned everithing is running fast and safe an smooth. Bye Andrea Forghieri Andrea, - Original Message - From: Andrea Forghieri [EMAIL PROTECTED] Newsgroups

Mysql 4.0.4 + InnoDB leads to corrupted tables ?

-s) from another DB. Could this be the tricky combo ? The following is the configuration of the cpu that runs mysql : OS : Linux (Mandrake 8.2) kernel 2.4.3-20 Mysql : 4.0.4 CPU : Pentium III 800 RAM : 127 Mb Best Regards Andrea Forghieri Emmegi S.p.A

Bug in FLOOR() function

Dear Sirs, please try this with Mysql 4.0.2 SELECT 25*9.54; - 238.5 (so far so good) then SELECT (25*9.54)+0.5; - 239.000 (still OK ) SELECT FLOOR((25*9.54)+0.5); - 238 (ouch !!) Best Regards Andrea Forghieri Emmegi S.p.A. # Useful

Create ... select bug

-log wait_timeout 28800 Note : You did a great job with multi-table delete !!! THX for existing! Best Regards Andrea Forghieri Project Manager Emmegi S.p.A. - Before posting, please check: http://www.mysql.com/manual.php

Create ... select bug

-log wait_timeout 28800 Note : You did a great job with multi-table delete !!! THX for existing! Best Regards Andrea Forghieri Project Manager Emmegi S.p.A. - Before posting, please check: http://www.mysql.com/manual.php

Unique indexes and case sensitivity bug(?)

Description: MYSQL returns ERROR 1062: Duplicate entry 'xx' for key x when creating a UNIQUE KEY on CHAR fields that contain more occurencies of the same value written with different cases. See example below. How-To-Repeat: Please run these few SQL statements CREATE TABLE dummy (a