|List:||General Discussion||« Previous MessageNext Message »|
|From:||Mitchell Maltenfort||Date:||April 10 2010 12:42am|
|Subject:||fast update with 1:1 table?|
|View as plain text|
I have two tables, A and B. B has newer data, A has more columns. I want to update some of the columns in A with all but one of the columns in B. They have the same number of records -- about eight million -- and one key column in common for matching. (That's the one from B I don't want to update) I get the idea that using UPDATE...WHERE is not my fastest option. Can anyone suggest an alternative? Not sure about LOAD INFILE and REPLACE because they seem to cover entire rows. Thanks in advance.
|• fast update with 1:1 table?||Mitchell Maltenfort||10 Apr|
|• Re: fast update with 1:1 table?||Ananda Kumar||10 Apr|