Can I import tab-separated files into MySQL without creating database tables first? -
As the title says: I have a set of separate text files from a tab containing data < P> I know that if I manually use 'Create Table' to set all the tables, then I can import them into wait tables using 'load data' or 'mysinklinport'.
But is there any way to automate the tables based on tab files? It seems that there should be (I know that MySQL may have to guess the data type of each column, but you can specify it in the first row of the tab file.)
No, it is not. In either case, you first need to create
a table
.
Automatically creating tables and estimating field types is not a part of DBMS job. This is the best job for an external device or application (which then creates the required details).
Comments
Post a Comment