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
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
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 ba
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
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.
http://ideas.live.com/programpage.as
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 to
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(){
PreparedStat
iginal 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, e
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"
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 ro
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
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
12 matches
Mail list logo
