MySQL Forums
Forum List  »  Newbie

Re: IMPORT TABLE INTO MySQL
Posted by: Mark Snyder
Date: April 20, 2009 10:52AM

Yes, you have to defined (CREATE TABLE) first - you need a place for the data, column by column - each column will be defined as the appropriate type (integer, varchar, etc) based on the type of data in the input CSV file. Then you'll run LOAD DATA INFILE. You can do both of these commands from the Command Line - no scripting required.

Options: ReplyQuote


Subject
Written By
Posted
Re: IMPORT TABLE INTO MySQL
April 20, 2009 10:52AM
April 20, 2009 02:56PM
April 21, 2009 09:39AM
April 21, 2009 08:04AM
April 21, 2009 07:59AM


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.