Member Avatar for svijayakumaris

Hi,
I want to store the text data with apostrophe in the table.
I tried through this query like this
insert into temp values(101,'vijaya\'s');

but it is giving error - missing comma

Could anybody help this sql query for the following requirement?

NAME
vijaya's
rajani's

  • 2 Contributors
  • 5 Replies
  • 82 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by svijayakumaris
Member Avatar for debasisdas

try this sample query

insert into temp values(101,'vijaya''s');

hope that solves your problem.

Member Avatar for debasisdas

You are most welcome.
I am glad to know i could help you.

Member Avatar for svijayakumaris

You are most welcome.
I am glad to know i could help you.

Thankyou! its working.

Member Avatar for svijayakumaris

You are most welcome.
I am glad to know i could help you.

Thankyou! its working.

-vijaya

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.