1

I want to know exact reason why this error occur playing with quotes.

INSERT INTO table_check(name) VALUES('hello'hi') -- ERROR
INSERT INTO table_check(name) VALUES('hello''hi') -- RESULT:- hello'hi
INSERT INTO table_check(name) VALUES('hello'''hi') --ERROR
INSERT INTO table_check(name) VALUES('hello''''hi') --RESULT:- hello''hi
INSERT INTO table_check(name) VALUES('hello'''''hi') --ERROR
INSERT INTO table_check(name) VALUES('hello''''''hi') --RESULT:- hello'''hi
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Amee
  • 337
  • 4
  • 14

1 Answers1

5

Single Quotes are Escaped by Doubling Them up.So whenever even number of Quotes are present, then we get the Result.

To Know The Behavior of Single Quotes Try to Run This Below Code:

Select '','''','''''','''''''',''''''''''

So,Single Quotes Should be Even Number Else We get error like:Unclosed quotation mark after the character string ') -- ERROR

Dalton
  • 1,334
  • 1
  • 11
  • 19
Aj.na
  • 283
  • 2
  • 9