To insert a single quotes in a table using query

Question

I want to insert single quotes with the data in which I am trying to insert it in a mysql table Example id column 1 data='rose'

data='rose' should be saved under column My Actual query is UPDATE test SET ItemType ='doctype="\'text'\"'WHERE ITEMINDEX='221'

If the column has type of `char/varchar/text` etc. there is no reason to unsave quotes. You do something wrong, didn't show us code. — pavel, Dec 05 '17 at 07:35
I used update table set column='data='\rose'\' where id=1 but it is not working — Dhivya, Dec 05 '17 at 07:36
Possible duplicate of [Insert a value containg single quotes in MySQL](https://stackoverflow.com/questions/887036/insert-a-value-containg-single-quotes-in-mysql) — Lalit Verma, Dec 05 '17 at 07:38
@Dhivya: try to find how to escape quotes in SQL. It's easy. — pavel, Dec 05 '17 at 07:38
@panther I used escaping character but still its not working. — Dhivya, Dec 05 '17 at 07:40

score 0 · Answer 1 · answered Dec 05 '17 at 10:23

0

Thanks.The following code solved my issue UPDATE test SET ItemType ='doctype=''text''' WHERE ITEMINDEX='221'

answered Dec 05 '17 at 10:23

Dhivya

1 Answers1