How can i use double quotes inside sql update query?

Question

I am trying to fire following command

update employees set text_data="[Demo-Data value="mddhak"]";

I am getting following error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

XBD · Answer 1 · 2022-09-09T11:08:46.730

-1

You can use SINGLE QUOTES instead to achieve the same

update employees set text_data='[Demo-Data value="mddhak"]';

edited Sep 09 '22 at 11:08

answered Sep 09 '22 at 11:07

XBD

You could. But what if there were single quotes in the value? – Nico Haase Sep 09 '22 at 11:09
You can use alternate single and double quotes. – XBD Sep 09 '22 at 11:12
Please add all clarification to your answer by editing it. What do you mean by "alternate"? – Nico Haase Sep 09 '22 at 11:13

1 Answers1