Import CSV and other formats
Posted by:
st n
Date: April 23, 2012 07:12AM
Hi,
How can tables from CSV- and other textfiles be imported into mysql?
The data can be imported with "load data..." but that does not create nor check the structure of the tables. "Load data" only works if the table already exists and already has the correct structure.
Here we have project-related tables in textfiles that are generated by different software and change their structure frequently so keeping the mysql-table-structures up to date is quite a drag. So I am hoping that there is some mysql-command or tool that will help out.
THX,stn
Subject
Views
Written By
Posted
Import CSV and other formats
4220
April 23, 2012 07:12AM
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.