What is idea behind escape characters?
Dear Experts
I am starting with mySQL and I cannot understand all the concept of escape characters in strings.
What was idea behind this? I have feeling that it makes my life just more difficult if I want to assure that string which I have in variable is indeed stored in mySQL in exact form.
Many thanks for your advices
Vladimir
I am starting with mySQL and I cannot understand all the concept of escape characters in strings.
What was idea behind this? I have feeling that it makes my life just more difficult if I want to assure that string which I have in variable is indeed stored in mySQL in exact form.
Many thanks for your advices
Vladimir
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Can you give us an example of something you are trying to write to the database for which you feel you need to make use of escaping?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Dear Experts
many thanks for your explanations, I think I can understand need for character escaping now.
Thanks a lot again
V
many thanks for your explanations, I think I can understand need for character escaping now.
Thanks a lot again
V
MySQL Server
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
49K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Adding a backslash character (\) before certain other characters forms a special command. For example:
\n "escapes" the literal letter "n" and instead is interpreted as a new line:
mysql> SELECT 'Paul nNeralich';
Paul nNeralich
mysql> SELECT 'Paul \nNeralich';
Paul
Neralich