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 =
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.