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
Post a Comment