GoFuckYourself.com - Adult Webmaster Forum - View Single Post

alex79 · 09-30-2006, 12:51 AM

i have some text files that i want to import in mysql..
fields are delimitated by "|"
first row contain the columns name
is there any possibility to import them directelly to mysql without creating the tables first? tables must be autocreated from first line in the moment of the import..
i know there is mysqlimport utility but require that tabels to be already created before the import..

09-30-2006, 12:51 AM
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	mysql import from text file i have some text files that i want to import in mysql.. fields are delimitated by "\|" first row contain the columns name is there any possibility to import them directelly to mysql without creating the tables first? tables must be autocreated from first line in the moment of the import.. i know there is mysqlimport utility but require that tabels to be already created before the import.. __________________