[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Mysql LOAD DATA INFILE

Posted on 2009-02-17
1
Medium Priority
?
487 Views
Last Modified: 2013-12-13
Hello,

I am using the mysql LOAD DATA INFILE command but some of the data in my delimited file contains slashes and or quotes etc.  When I run the LOAD DATA command mysql strips the data of the slashes.  How can I prevent mysql from stripping/dropping the slashes?

Thank you.
0
Comment
Question by:AncientFrib
1 Comment
 
LVL 5

Accepted Solution

by:
synx earned 1500 total points
ID: 23662636
I would look at this article: http://dev.mysql.com/doc/refman/5.1/en/load-data.html

I think properly using the "Enclosed By" and "Escaped By" parameters could be your answer.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month18 days, 10 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question