Manage Learn to apply best practices and optimize your operations.

Correct commands for "load data"

MySQL expert Mike Hillyer recommends the correct commands for issues involving the "load data."

I have a problem with "load data." How do I load a file separated by "|"?

This depends on what the "|" character is separating.

The documentation for "load data" is located here and explains the different potential uses of a separator.

If "|" separates fields, use fields terminated by "|." If "|"separates rows, use lines terminated by "|."

This was last published in January 2006

Dig Deeper on Linux servers



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.