Re: Batch update

On 2/14/2012 10:30 AM, cars...@bitbybit.dk wrote: On 14.02.2012 10:20, Alex Schaft wrote: Hi, I need to update a table along the lines of the following update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def' and Key2 = 'ghi' I need to possible do anywhere from 2 to 20 of the

Re: Batch update

On 14.02.2012 10:20, Alex Schaft wrote: Hi, I need to update a table along the lines of the following update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def' and Key2 = 'ghi' I need to possible do anywhere from 2 to 20 of these. Would it be better to call an update statem

Re: Batch Update of records

Hallo Neil, take a look at the utility mysqlimport which will exactly fit your needs importing those records into a database table. The basic syntax is: mysqlimport database_name table_name.txt Tablename.txt would be your datafile with the records. The filename must match the name of the t

Re: "Batch" Update?

For reference, multiple-table updates are documented in the manual . They work starting with mysql 4.0.4. Michael Peter Brawley wrote: UPDATE tableA, tableB SET tableA.column2 = tableB.column2 WHERE tableA.rowID = tableB.rowID; PB - Original

Re: "Batch" Update?

UPDATE tableA, tableB SET tableA.column2 = tableB.column2 WHERE tableA.rowID = tableB.rowID; PB - Original Message - From: John Mistler To: [EMAIL PROTECTED] Sent: Saturday, May 29, 2004 12:16 AM Subject: "Batch" Update? Let's say I have a table "A" with 25 columns. I also

RE: Batch UPDATE with C API

On 22-Jun-01 Jean-Philippe Cote wrote: > > > Hello, > > Suppose I want to update n rows (where n is a possibly large number) > using the mySQL C API. I can create n separate UPDATE > statements and send each of them to the server with mysql_[real_]query(), > but that doesn't seem particularly