2个方法:
1,用"/"转义:
INSERT INTO tab (field1) VALUES('i/'m dreaming');
SELECT * FROM tab where field1='i/'m dreaming';
2,用2个单引号'':
INSERT INTO tab (field1) VALUES('i''m dreaming');
SELECT * FROM tab WHERE field1='i''m dreaming';
2个方法:
1,用"/"转义:
INSERT INTO tab (field1) VALUES('i/'m dreaming');
SELECT * FROM tab where field1='i/'m dreaming';
2,用2个单引号'':
INSERT INTO tab (field1) VALUES('i''m dreaming');
SELECT * FROM tab WHERE field1='i''m dreaming';