update a row in a table from another row within the same table

Hi listers, using mysql 4.1.7 on SuSE Linux 9.1. I have a table containing config parameters for a web based application. this table has one particular row with the main key of "example". whenever a new customer joins this application, the registration application copies this example row and cre

update a row in a table from another row within the same table

Hi listers, using mysql 4.1.7 on SuSE Linux 9.1. I have a table containing config parameters for a web based application. this table has one particular row with the main key of "example". whenever a new customer joins this application, the registration application copies this example row and create

how escape special in a field

Hi, I find there seems problem with this select statement when there is a special character inside the table. i.e. select concat(field_1, ',', field_2) as name where ... field_2 actually is something like 'George, Banson' ( with a comma in between ) i guess this , destroy the SQL syntax. I

Re: mysqldump + debug option not working

Got it. I did a mysql --help and saw that debug-info is set to FALSE...so I need to compile MySQL with debugging support. Thanks for all the help!! Cheers Manoj - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "ManojSW" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: M

Re: mysqldump + debug option not working

I am not sure. I installed it from an RPM version long time back (not sure if that RPM was compilied with debugging support). Is there anyway to check If I am running a debugging supported version?? Apologies if this is a FAQ. Manoj - Original Message - From: "Paul DuBois" <[EMAIL PROTE

Re: mysqldump + debug option not working

At 11:19 +0900 12/13/04, ManojSW wrote: Hi, I am running MySQL (4.0.15 max log) & mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug,

mysqldump + debug option not working

Hi, I am running MySQL (4.0.15 max log) & mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug, --debug = 'd:t:o,debug.log' ,

Are these variables "healthy"?

Hi, I am running an instance of MySQL 4.0.16, mostly using MyISAM tables on a 18G 10kRPM SCSI drive w/ ext3, the server having 2G RAM and a 2.8G HT P4, on a RedHat 9 install. Would some of you experts be so kind to take a look at the variables I have, and tell me if anything is wrong? I think t

RE: mysqlcc

Hi Robin Have you checked you have INSERT authorities to the database as the user you connected as? I have mysqlcc 0.9.2-beta (on Win2k) connecting to a mySQL 4.0.20 (Linux) database and it's been working fine for months. Graham > -Original Message- > From: Robin Lynn Frank [mailto:[EMA

InnoDB status: why do I see MyISAM requests?

Just curious... While running SHOW INNODB STATUS, the "list of transactions for each sessions" part shows queries that are only related to MyISAM tables. Is it the expected behavior? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Newbie question about index (why are they not updating?)

I've created a table with several indexes as follows: $query = "CREATE TABLE `data_raw` ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, run_id VARCHAR(20) DEFAULT 'error_internal' NOT NULL, time_run DATETIME DEFAULT '-00-00 00:00:00' NOT NULL, ...clip. PRIMARY KEY (id), INDEX x_run_id (run_id),