Hi,
I have a text file with fixed-width columns that I'd like to get loaded into a table. Against Oracle the script would be as follow:
LOAD DATA INFILE 'myfile.data' append INTO TABLE MYTABLE ( FIELD1 POSITION(1:10), FIELD2 POSITION(11:20), FIELD3 POSITION(21:21), FIELD4 POSITION(22:40) )
Is there an equivalent to the Oracle "POSITION" parameter in MySQL? Or any MySQL add-on that makes such a load possible?
Adam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]