load_data from flat text file

I have a totally flat text file with a record length of 21.

How do I finish this query to send every 21 characters to a row named raw?

LOAD DATA LOCAL INFILE
‘e:/usps/crs1508b/685.txt’
INTO TABLE cris
SET raw =

Wrote a php script that turned the source file into a file that’s delimited. Problem solved.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.