Software Developer

Pages

  • Home
  • C / C++
  • Java
  • Hibernate
  • Spring
  • Structs
  • JBoss
  • PHP
  • VB.NET
  • Database
  • About Me

Friday, December 5, 2014

how to do a SQL insert with a value with an apostrophe in it

INSERT INTO Person
    (First, Last)
VALUES
    ('Joe', 'O''Brien')
              /\
             here  
Posted by Sout Saret at 1:29 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database Management
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Live Chat

Search

Categories

  • C Programming (6)
  • Database Management (67)
  • Hibernate (7)
  • Java (102)
  • JBoss (8)
  • PHP Programming (9)
  • Spring (5)
  • Structs Framework (3)
  • VB.NET (48)

Blog Archive

  • ►  2016 (6)
    • ►  August (1)
      • ►  Aug 24 (1)
    • ►  July (5)
      • ►  Jul 28 (1)
      • ►  Jul 22 (4)
  • ►  2015 (2)
    • ►  January (2)
      • ►  Jan 14 (1)
      • ►  Jan 13 (1)
  • ▼  2014 (43)
    • ▼  December (1)
      • ▼  Dec 05 (1)
        • how to do a SQL insert with a value with an apostr...
    • ►  November (2)
      • ►  Nov 03 (2)
    • ►  October (1)
      • ►  Oct 24 (1)
    • ►  September (3)
      • ►  Sep 29 (2)
      • ►  Sep 11 (1)
    • ►  July (1)
      • ►  Jul 14 (1)
    • ►  May (4)
      • ►  May 29 (2)
      • ►  May 22 (1)
      • ►  May 21 (1)
    • ►  April (4)
      • ►  Apr 08 (2)
      • ►  Apr 03 (1)
      • ►  Apr 01 (1)
    • ►  March (12)
      • ►  Mar 29 (1)
      • ►  Mar 28 (1)
      • ►  Mar 26 (1)
      • ►  Mar 25 (1)
      • ►  Mar 21 (2)
      • ►  Mar 20 (1)
      • ►  Mar 15 (2)
      • ►  Mar 13 (1)
      • ►  Mar 12 (1)
      • ►  Mar 07 (1)
    • ►  February (5)
      • ►  Feb 18 (2)
      • ►  Feb 11 (1)
      • ►  Feb 05 (2)
    • ►  January (10)
      • ►  Jan 28 (1)
      • ►  Jan 26 (2)
      • ►  Jan 22 (2)
      • ►  Jan 16 (1)
      • ►  Jan 14 (1)
      • ►  Jan 10 (1)
      • ►  Jan 09 (1)
      • ►  Jan 02 (1)
  • ►  2013 (92)
    • ►  December (3)
      • ►  Dec 09 (1)
      • ►  Dec 04 (1)
      • ►  Dec 01 (1)
    • ►  November (6)
      • ►  Nov 29 (3)
      • ►  Nov 12 (3)
    • ►  October (11)
      • ►  Oct 30 (1)
      • ►  Oct 29 (4)
      • ►  Oct 28 (1)
      • ►  Oct 24 (1)
      • ►  Oct 21 (3)
      • ►  Oct 08 (1)
    • ►  September (10)
      • ►  Sep 26 (1)
      • ►  Sep 25 (1)
      • ►  Sep 23 (2)
      • ►  Sep 19 (1)
      • ►  Sep 18 (2)
      • ►  Sep 09 (1)
      • ►  Sep 03 (2)
    • ►  August (16)
      • ►  Aug 28 (1)
      • ►  Aug 23 (1)
      • ►  Aug 22 (1)
      • ►  Aug 19 (1)
      • ►  Aug 18 (1)
      • ►  Aug 14 (11)
    • ►  July (8)
      • ►  Jul 23 (1)
      • ►  Jul 22 (2)
      • ►  Jul 17 (2)
      • ►  Jul 09 (1)
      • ►  Jul 04 (2)
    • ►  June (11)
      • ►  Jun 27 (1)
      • ►  Jun 26 (1)
      • ►  Jun 16 (5)
      • ►  Jun 11 (1)
      • ►  Jun 06 (3)
    • ►  May (5)
      • ►  May 27 (2)
      • ►  May 23 (2)
      • ►  May 22 (1)
    • ►  March (4)
      • ►  Mar 22 (3)
      • ►  Mar 04 (1)
    • ►  February (4)
      • ►  Feb 28 (2)
      • ►  Feb 11 (1)
      • ►  Feb 07 (1)
    • ►  January (14)
      • ►  Jan 23 (1)
      • ►  Jan 15 (3)
      • ►  Jan 11 (4)
      • ►  Jan 09 (2)
      • ►  Jan 04 (1)
      • ►  Jan 03 (3)
  • ►  2012 (110)
    • ►  December (14)
      • ►  Dec 27 (1)
      • ►  Dec 20 (3)
      • ►  Dec 15 (1)
      • ►  Dec 14 (1)
      • ►  Dec 12 (2)
      • ►  Dec 11 (3)
      • ►  Dec 03 (3)
    • ►  November (6)
      • ►  Nov 12 (1)
      • ►  Nov 07 (4)
      • ►  Nov 01 (1)
    • ►  October (7)
      • ►  Oct 25 (4)
      • ►  Oct 23 (2)
      • ►  Oct 05 (1)
    • ►  September (13)
      • ►  Sep 27 (5)
      • ►  Sep 25 (1)
      • ►  Sep 14 (1)
      • ►  Sep 12 (1)
      • ►  Sep 10 (1)
      • ►  Sep 09 (1)
      • ►  Sep 07 (1)
      • ►  Sep 06 (1)
      • ►  Sep 02 (1)
    • ►  August (22)
      • ►  Aug 30 (6)
      • ►  Aug 29 (2)
      • ►  Aug 28 (1)
      • ►  Aug 23 (7)
      • ►  Aug 21 (2)
      • ►  Aug 10 (2)
      • ►  Aug 08 (1)
      • ►  Aug 04 (1)
    • ►  July (4)
      • ►  Jul 26 (2)
      • ►  Jul 22 (1)
      • ►  Jul 12 (1)
    • ►  June (4)
      • ►  Jun 21 (4)
    • ►  May (20)
      • ►  May 22 (3)
      • ►  May 11 (2)
      • ►  May 09 (4)
      • ►  May 04 (2)
      • ►  May 03 (5)
      • ►  May 02 (4)
    • ►  April (20)
      • ►  Apr 27 (1)
      • ►  Apr 26 (2)
      • ►  Apr 25 (1)
      • ►  Apr 24 (3)
      • ►  Apr 23 (7)
      • ►  Apr 22 (6)

My Profile

My photo
Sout Saret
I Love Programming Language and Database Programming
View my complete profile

  • free counters

Learning Guide

  • Java Programming
  • Oracle Documentation (Main Page)
  • Oracle Error Message
  • Oracle10g Release 1 (10.1)
  • Oracle10g Release 2 (10.2)
  • Oracle11g Release 1 (11.1)
  • Oracle11g Release 2 (11.2)
  • Oracle8i Database 8.1.7
  • Oracle9i Database 9.0.1
  • Oracle9i Database 9.2

Oracle Application Server Docs

  • Oracle10g (9.0.4)
  • Oracle10g Release 2 (10.1.2)
  • Oracle10g Release 3 (10.1.3)
  • Oracle9i (9.0.2)

Free Source Code

  • Postgres-XC
  • PostgreSql Database
  • PostgreSql Admin
  • PostgreSQL
  • JSP Guide
  • Addition Link to learn more and more
  • The best resource concept for developer
  • Please click to join with learning programming
Picture Window theme. Powered by Blogger.