--- mos <mos99@stripped> schrieb: > At 12:23 PM
Thanks a lot, Mike.
It works.
I spent many hours with this problem.
I also tried the trick with a temporary table,
but used the "INSERT" command, which didn't help.
All the best to you, Harald
>
> Harald,
> 1) load the data into a temporary table
> whose structure matches
> that of the data in your text file
>
> CREATE TABLE `tableb` (
> `Rcd_Id` int(10) NOT NULL auto_increment,
> `cust_name` char(10) default NULL
> )
>
> 2) Load the data into the temp tableb using
> "Load Data Infile ..."
>
> 3) Once the data is in a database table,
> you can update an
> existing table wrt to another table doing something
> like:
>
> update tablea, tableb set tablea.cust_name =
> tableb.cust_name where
> tablea.rcd_id=tableb.rcd_id
>
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
>
___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden:
http://mail.yahoo.de
