Re: How to load fixed-format data?

2004-04-27 Thread Bob Ramsey
Roy Smith wrote: I've got a bunch of files which contain packed fixed-field-width records. The records are pretty long; depending on the file, as long as 1000 characters and 10's of fields. Fields are a mix of numeric and alphanumeric types. What's the best way to load these into mysql? Mys

How to load fixed-format data?

2004-04-27 Thread Roy Smith
I've got a bunch of files which contain packed fixed-field-width records. The records are pretty long; depending on the file, as long as 1000 characters and 10's of fields. Fields are a mix of numeric and alphanumeric types. What's the best way to load these into mysql? Mysqlimport looks lik