MySQL Forums
Forum List  »  Other Migration

Import CSV and other formats with table structure
Posted by: st n
Date: April 24, 2012 02:43AM

Hi,

sorry about the double post. I noticed that the subject did not describe the problem.

How can tables from CSV- and other textfiles be imported into mysql in a way that the corresponding table is created in the process ?

The data itself 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

Options: ReplyQuote


Subject
Views
Written By
Posted
Import CSV and other formats with table structure
3753
April 24, 2012 02:43AM


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.