Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Is there some sort of escape character I can use when importing a CSV file into MySQI so that I can get s "/" to show up as text?

Posted on 2011-03-01
3
Medium Priority
?
397 Views
Last Modified: 2012-05-11
Is there some sort of escape character I can use when importing a CSV file into MySQI so that I can get s "/" to show up as text?

Thanks,
Rip
0
Comment
Question by:abacusarts
3 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 1000 total points
ID: 35011507
" ` " is used as escape character in MySql if you want to use special characters in table name or field name or want to use any reserved word of mysql as table name.

Create table `aa/njh` (col1 INT);
0
 

Author Comment

by:abacusarts
ID: 35011741
No did not work for me I tried  entering '/' to get a slash and it did not work I have also tried \/ and "/" neither worked either
0
 
LVL 8

Assisted Solution

by:wolfgang_93
wolfgang_93 earned 1000 total points
ID: 35011978
Try the prime symbol (upper left of my keyboard) "`", not the characters that you used.

It would help if you entered here an example of the command you are trying to execute
unsuccessfully.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month6 days, 13 hours left to enroll

782 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