This depends on what the "|" character is separating.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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 "|."
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.