Re: Optimize db update

["Velen" <velen@xxxxxxxxxx>]

Thanks for your advice.

I found another way of doing it.

from DatabaseB:
Select * into outfile 'data.txt' from TableB

then on DatabaseA:
Load data infile 'data.txt into TableB

then on DatabaseA, I can run any validation on TableB before inserting it in
TableA.


Velen

----- Original Message -----
From: "Daniel Brown" <parasane@xxxxxxxxx>
To: "Velen" <velen@xxxxxxxxxx>
Cc: <mysql@xxxxxxxxxxxxxxx>
Sent: Friday, March 21, 2008 6:10 PM
Subject: Re: Optimize db update


> On Fri, Mar 21, 2008 at 10:04 AM, Velen <velen@xxxxxxxxxx> wrote:
> > This one is alright but is there an alternative that can be run with the
> >  mysql> prompt?
>
>     Not to dump a file, but to import, yes.  Check out the LOAD DATA
> INFILE command:
>         http://dev.mysql.com/doc/refman/5.0/en/load-data.html
>
> --
> </Daniel P. Brown>
> Forensic Services, Senior Unix Engineer
> 1+ (570-) 362-0283
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=velen@xxxxxxxxxx
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx