如何将半角的'通过sql文执行写入数据库中？？？

[compass76]

INSERT INTO aa VALUES(1,'', CURRENT TIMESTAMP )
现在第二字段的值是半角的'，这时候INSERT INTO aa VALUES(1,''', CURRENT TIMESTAMP )执行就会出错！
这种情况sql文如何写？？？

[yujohny]

INSERT INTO aa VALUES(1,'''', CURRENT TIMESTAMP )

[pengdali]

INSERT INTO aa VALUES(1,'''', CURRENT TIMESTAMP )

如：

select '''',char(39),''''''

[sdhdy]

INSERT INTO aa VALUES(1,'''', CURRENT TIMESTAMP )

[aierong]

''==='

[aierong]

INSERT INTO aa VALUES(1,char(39), CURRENT TIMESTAMP )

[aierong]

''==='

[compass76]

如果我查询语句中select * from aa where a='xxxx'xx' or b='yyyy'
xxxx'xx是字符串，这时候这条语句改如何写呢？？

[啊呀]

xxxx''xx