MySQL Forums
Forum List  »  CSV Storage Engine

Import txt files with fixed width
Posted by: mariacristina branca
Date: June 27, 2014 06:46AM

hi,
I have to do a procedure to import data from text files.
The fields have fixed width and are not delimited with "; " character or similar.
I can not use sql like this:
LOAD DATA INFILE '/ tmp / test.txt' INTO TABLE test FIELDS TERMINATED BY ';'

Thanks a lot

Options: ReplyQuote


Subject
Views
Written By
Posted
Import txt files with fixed width
2597
June 27, 2014 06:46AM


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.