MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Using quotes and apostrophe in an INSERT INTO query.
Posted by: Paul McArdle
Date: June 28, 2005 05:57PM

see http://dev.mysql.com/doc/mysql/en/string-syntax.html

SELECT 'hello', '"hello"', '""hello""', 'hel''lo', '\'hello', "hel'lo";
hello | "hello" | ""hello"" | hel'lo | 'hello | hel'lo

depends on how strings are quoted.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Using quotes and apostrophe in an INSERT INTO query.
Atrox Mavenia
June 28, 2005 02:06PM
Re: Using quotes and apostrophe in an INSERT INTO query.
Paul McArdle
June 28, 2005 05:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.