As a word of advice, before posting to any list, please RTFM (Read The Fine Manual).
You have to escape all "special characters", like apostrophes and single
quotes, with the backslash.
INSERT INTO thetable (name) VALUES ('O\'Connell');
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
J.R.
-----Original Message-----
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Monday, May 15, 2006 1:37 AM
To: mysql@lists.mysql.com
Subject: Inserting ' into database
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
