Re: IMPORT TABLE INTO MySQL
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.
Subject
Written By
Posted
Re: IMPORT TABLE INTO MySQL
April 20, 2009 10:52AM
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.