Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to use the mysqlimport command on a file that has no column delimiters?

I would like to import the ctl file used with the sqlloader for Oracle

share|improve this question
Is it fixed width? – ypercubeᵀᴹ Sep 24 '12 at 15:28
See this similar question: Convert fixed length text file into SQL – ypercubeᵀᴹ Sep 24 '12 at 15:30
yes you're right, I tried that and it works, I think this question could be closed as exact duplicate of the one you suggested, how do I close this ? – Murko Sep 25 '12 at 7:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.