Question

Publisher table contains id and name columns. Id is auto incremented and name is of varchar(40) type. Which of the following queries will execute correctly?

Cosmo · Accepted Answer

Single quotation mark symbol should be escaped - 'O''Reilly'

Cosmo · Accepted Answer

insert into publisher (name) values ('OREILLY');

Cosmo · Accepted Answer

insert into publisher (name) values ('O Reilly');

Cosmo · Accepted Answer

insert into publisher (name) values ('O-Reilly');

Cosmo · Answer

insert into publisher (name) values ('O'Reilly');

Follow CodeGalaxy

Mobile Beta