String contains a quote '

String contains a quote '

schema:scott

If the data contains a single quote it must be escaped.

DELETE FROM t_q

DROP TABLE t_q;
CREATE TABLE t_q (a VARCHAR(8));

INSERT INTO t_q VALUES ('O''Brian');
SELECT * FROM t_q

INSERT and DELETE Operations

INSERT new records

UPDATE existing records

DELETE records

INSERT ... SELECT

INSERT: Not all fields need to be specified

INSERT a date

Explicitly enter a NULL

INSERT problems: reference

DELETE problems: reference

INSERT problems: incompatible formats

String contains a quote '

Data normalization