Apostrophe

From SQLZOO
Revision as of 12:22, 12 July 2012 by Marek (Talk | contribs)

Jump to: navigation, search

How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'

schema:scott
DROP TABLE cia;
CREATE TABLE cia(name VARCHAR(10), region VARCHAR(10));
INSERT INTO cia VALUES ('Cote d''Ivoire', 'Africa');
INSERT INTO cia VALUES ('Japan', 'Asia');
SELECT * FROM cia
WHERE name = 'Cote d''Ivoire'
SELECT * FROM cia
WHERE name = 'Cote d''Ivoire'
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense