mysqlimport

[rchicho]

Necesito importar a una tabla MySQL datos de un archivo de texto, donde los campos están seperados por tabuladores, pero el orden y cantidad de los campos en el archivo texto no coincide con el de la tabla MySQL.

¿Alguien conoce cómo conformar el comando com mysqlimport o con load data infile?

I need to import data fro text file to MySQL table, in text file field are separated by TABs, but field's order and quantity are not the same as in the MySQL table.

Somebody can help me to write instructions whit mysqlimport or with load data infile?

[ronverdonk]

As far as I understand, fields in an input record of the file must have the same order as the table columns. So you could create a temporary table with the columns in the same order as the fields in each file-record. After importing you could then copy the contents of the temp table to the destination table.
As for the TABs, when you miss them at the end of the record, it wouldn't matter much, but if they are in the middle of the record you'd have a problem.

Ronald :cool: