Q

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 first published in January 2006

Dig deeper on Linux management and configuration

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close