f*******h
发帖数: 1269 | 1 When I:
INSERT INTO mytable(name, desc) VALUES('Test Name', 'It's a good test')
this will cause problem, because ' after It.
How could I do? | p*****e
发帖数: 58 | 2
INSERT INTO mytable(name, desc) VALUES('Test Name', 'It''s a
good test')
use '' (two single quote) for '. SQL uses ' as the escape
charactor like the \ in C/C++, or " in VB.
【在 f*******h 的大作中提到】
: When I:
: INSERT INTO mytable(name, desc) VALUES('Test Name', 'It's a good test')
: this will cause problem, because ' after It.
: How could I do?
|
|
