On 21 Aug 2002, at 5:01, Joseph Grundy wrote: > Example I have a table created lets say prices, in table prices > there are 15 columns named 1 through 15. I want to be able to > populate one column say 8 with data I exported from a column > in a different database, using the txt file.
So you have an already existing table and you want to update one column of it from a text file that contains only one column? Is that correct? How do you know which row in the text file goes with which row in the table? In any case, LOAD DATA won't be able to do that, because it's for doing inserts, not updates. In order to do anything useful with the text file, it seems to me that you'll first have to add at least one more column to it, containing the primary key from the table that the data is going into. You'll need something to join on. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
