Re: MySQL-php UPDATE errors

2001-05-13 Thread FJocelin
Hi, Try $saveQuery = "UPDATE $table_product SET PROD_PRICE = '$value' WHERE PROD_ID = '$key'"; instead of $saveQuery = "UPDATE $table_product SET PROD_PRICE = \"$value\" WHERE PROD_ID = \"$key\""; Jocelyn Fournier Presence-PC www.presence-pc.com Dans un e-mail daté du 14/05/2001 01:37:19 P

Key_Writes > Key_write_requests ???

2001-05-08 Thread FJocelin
Hi, Mysqladmin shows me : | Key_write_requests | 80850 | | Key_writes | 112447| What does it mean, and how could this be possible ? Thank you, Jocelyn Fournier Presence-PC www.presence-pc.com

Re: char -> varchar ?

2001-05-07 Thread FJocelin
Hi, Char columns are used with fixed-length type table, whereas varchar are used with dynamic table. If you have varchar columns in your table, all char columns will be convert to varchar column (you can't have a fixed-length table if your table contain varchar, blob or text field). Here are

Strange optimizer choice...

2001-05-06 Thread FJocelin
I have two tables with exactly the same structure : CREATE TABLE threadhardwarefr9 (numeropost bigint(20) unsigned DEFAULT '0' NOT NULL, icone tinyint(2) unsigned DEFAULT '0' NOT NULL, numreponse bigint(20) unsigned NOT NULL auto_increment, contenu text NOT NULL,pseudo varchar(35) NOT NULL, date

REPLACE DELAYED bug with MySQL 3.23.36

2001-03-29 Thread FJocelin
Hi ! I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM tables. The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35. The bug occurs randomly and makes MySQL restart... With REPLACE instead of REPLACE DELAYED, there seems to be no problem. Here is

REPLACE DELAYED bug with MySQL 3.23.36

2001-03-29 Thread FJocelin
Hi ! I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM tables. The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35. The bug occurs randomly and makes MySQL restart... With REPLACE instead of REPLACE DELAYED, there seems to be no problem. Here is