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?

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
abacusartsAsked:
Who is Participating?
 
tigin44Connect With a Mentor Commented:
" ` " 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
 
abacusartsAuthor Commented:
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
 
wolfgang_93Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.