Insert a Value that Contains an Apostrophe in SQL Example
Let’s look at some examples of how to add apostrophes in an SQL table.
Example 1
The example statement shows the insertion of a name with an apostrophe. To avoid syntax errors, the apostrophe within “John’s” is escaped by doubling it (”). This ensures that SQL reads it correctly and doesn’t misinterpret it as the end of the string. Here, We are inserting the value “John’s Sen” in the name column in the Name table.
Here, the challenge is to insert a value with an apostrophe in the table. Here we have apostrophes in John’s so we have to insert it into table with apostrophe included.
INSERT INTO Name (name) VALUES ('John''s Sen');
Output:
In this example, John’s Sen is the value being inserted, and the single quote in “John’s” is escaped by doubling it.
- Name: The table is Name.
- ‘John”s Sen’: The value you want to insert. The apostrophe in “John’s” is escaped by doubling it (”).
This ensures that the SQL engine reads the double apostrophe as a single apostrophe within the value, and it won’t be treated as a delimiter for the SQL statement.
Example 2
Here, we are inserting value “The Guardian’s Guide to the Galaxy” in name column in Name table.
INSERT INTO Name (name) VALUES ('The Guardian''s Guide to the Galaxy');
Output:
We want to insert “The Guardian’s Guide to the Galaxy” So we have to Insert this “The Guardian”s Guide to the Galaxy” to get the correct output.
How to Insert a Value that Contains an Apostrophe in SQL?
SQL is a standard database language used to access and manipulate data in databases. SQL stands for Structured Query Language. SQL was developed by IBM Computer Scientists in the 1970s.
By executing queries SQL can create, update, delete, and retrieve data in databases like MySQL, Oracle, PostgreSQL, etc. Overall SQL is a query language that communicates with databases.