How do I insert a string that contains an '?

Question

I'm looking to include a value into my datatable but a string value includes a '. How do I add it to my table?

insert into mytable
(ISO_COUNTRY_CODE, COUNTRY, REGION)
values ('CI', 'COTE D'IVOIRE','EMEAR')

As you can see I will get an error if I input this like this.

score 0 · Accepted Answer · answered Jun 13 '23 at 22:30

0

Try the query

INSERT INTO mytable (ISO_COUNTRY_CODE, COUNTRY, REGION)
VALUES ('CI', 'COTE D''IVOIRE', 'EMEAR');

answered Jun 13 '23 at 22:30

Venkat

1

Wow! That worked! Thank you! – A Dolegowski Jun 13 '23 at 22:34
@AMorell could you accept the answer which will be helpful for other people who has issue with same type of question. – Venkat Jun 19 '23 at 01:51

1 Answers1