MySQL Forums
Forum List  »  Newbie

Re: importing single csv fields to multiple mysql tables
Posted by: Rick James
Date: June 02, 2014 12:15PM

(I agree with Phillip. But if you must...)

If you must use the CSV load,...
* Load the CSV file into a single temp table.
* Use INSERT ... SELECT ... to copy some fields to one of the real tables.
* ditto for the other two real tables.
* DROP the temp table.

Options: ReplyQuote


Subject
Written By
Posted
Re: importing single csv fields to multiple mysql tables
June 02, 2014 12:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.