Correct commands for "load data"

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

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top