List:General Discussion« Previous MessageNext Message »
From:Peter Lauri Date:May 15 2006 5:36am
Subject:Inserting ' into database
View as plain text  
Hi all,

Assume that I want to insert "Juanita O'Connell" into my database. How do I
do that? The problem is the ' in her last name. If I just put it in it will
be

INSERT INTO thetable (name) VALUES ('O'Connell');

And that does not work :) How can I solve this?

Best regards,
Peter Lauri

Thread
Inserting ' into databasePeter Lauri15 May
RE: Inserting ' into databaseJ.R. Bullington15 May