Jump to content

SOLVED load_data from flat (nondelimited) text file


Recommended Posts

I have a totally flat text file (nondelimited) with a record length of 120.

How do I finish this query to send every 120 characters to the row named raw which is a varchar with a width of 120?

LOAD DATA LOCAL INFILE'e:/usps/crs1508b/685.txt'INTO TABLE crisSET raw =


Edited by niche
Link to comment
Share on other sites

That saved me another hour of fruitless search. My hats off to you as always JSG.


What do you think of a php while loop with a query in it?


You don't seem sold on the stored procedure route.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...