mysql - Insert Query for HTML string in SQL -


i have sql database table name question.

i want insert value questiontitle html string. insert query

insert     question (questiontype,questionid,questiontitle)  values ("mrq",         "qnb5t6tkdms",         "<p><span style="font-family: comic sans ms,sans-serif; font-size:  small;">what original concentration of acid?</span></p>") 

when try execute query in sql gives error . how can work html string.

you have error in using " inside third inserted value

insert     question (questiontype,questionid,questiontitle)  values ('mrq',         'qnb5t6tkdms',         '<p><span style="font-family: comic sans ms,sans-serif; font-size: small;">          original concentration of acid?</span></p>'        ); 

you can use escape slashes


Comments

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -