How to do a SQL insert inside of varchar in mysql

Question

How I can do a insert of sql syntax inside of varchar in mysql?

example:

INSERT INTO vartemp (SQLSyntax)
VALUES ('UPDATE RegExample SET Field1 = 'abc', Field2 = 123 WHERE whereCond1 = 'abc'')

where:

Vartemp is my table of SQL Syntax.

RegExample is a example of table.

u want to store strin containing sql query? – Whencesoever Jan 21 '15 at 11:58 — Whencesoever, Jan 21 '15 at 11:58
i think that it not a good practice... – Pierry Jan 21 '15 at 12:06 — Pierry, Jan 21 '15 at 12:06
It's a just test to test a windows service – Lucas Selliach Jan 21 '15 at 12:10 — Lucas Selliach, Jan 21 '15 at 12:10

score 2 · Accepted Answer · answered Jan 21 '15 at 11:59

Is this what you want?

INSERT INTO vartemp (SQLSyntax)
    VALUES ('UPDATE RegExample SET Field1 = ''abc'', Field2 = 123 WHERE whereCond1 = ''abc''')

If so, all you need to do is properly escape the embedded single quotes in the string. The escape method for a single quote is two single quotes.

score 1 · Answer 2 · answered Jan 21 '15 at 12:00

1

simple:

change ' to double ''

answered Jan 21 '15 at 12:00

Pierry

2 Answers2