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 statement for each of these,
or should I do a
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
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
Hi
I've am updating a database with about 20,000 records. What is the best way to
perform these updates. Can I use batch updating ?
Thanks
Neil
_
Be one of the first to try Windows Live Mail.
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 options database_name table_name.txt
Tablename.txt would be your datafile with the records. The filename must
match the name
Hi Jeff, all!
Jeff Drew wrote:
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
I do not claim any JBDC knowledge, so I have
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
class DatabaseWriter{
int writeCount=0;
public DatabaseWriter(){
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
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 have an identical
table B with 25 columns (column names, indexes, everything the same). I
want to get the entry
Let's say I have a table A with 25 columns. I also have an identical
table B with 25 columns (column names, indexes, everything the same). I
want to get the entry of column 2 of every row of table B, and update
column 2 of every row of table A WHERE the rowID from table A matches
the rowID of
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 efficient to me. Is there a better
way to do it ? Can I
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
12 matches
Mail list logo
