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 ar

Error 1104 (too many records)

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 po

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

che2/modules Then I added the following lines in httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php php SetOutputFilter PHP Have fun Andrea Forghieri - Before posting, please check:

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 http://www.php.net

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

Mysql 4.0.4 + InnoDB leads to corrupted tables ?

YISAM tables "linked" (ln -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

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 Emm

Create ... select bug

ize 33554432 tmpdir /home/mysql/tmp/ version 4.0.2-alpha-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

Create ... select bug

ize 33554432 tmpdir /home/mysql/tmp/ version 4.0.2-alpha-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

Unique indexes and case sensitivity bug(?)

>Description: >How-To-Repeat: >Fix: THANX >Submitter-Id: <[EMAIL PROTECTED]> >Originator: root >Organization: >MySQL support: [none ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Di