--- mos <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > ___________________________________________________________ Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
