Question:
Is it possible to insert the single quote as part of a Name like O’Brian into a table using a SQL Insert Statement?
Answer:
Yes, use double quotes around the name.
For example:
insert into names (first,last)values (“Jim”,”O’Brian”)
Home » Inserting Quotations in Name to Table Column
Question:
Is it possible to insert the single quote as part of a Name like O’Brian into a table using a SQL Insert Statement?
Answer:
Yes, use double quotes around the name.
For example:
insert into names (first,last)values (“Jim”,”O’Brian”)
At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.
See our full editorial policy.