FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Difference of single quote and double quote in mysql





bernardnapoleon
what is the difference of single quote and double quote in mysql?

thanx
b4r4t
You are to lazy to check it yourself ? It's about 5 seconds on google , or wven on this forum search engine ...

First search result ...

http://www.frihost.com/forums/search.php?mode=results

This topic:
http://www.frihost.com/forums/vt-94812.html&highlight=double+quotes


You will find the answer ...

And for futrure - try to search yourself ... the PHP programmer whi can't find such an easy answers will be ... well ... not good Smile
rvec
b4r4t wrote:
You are to lazy to check it yourself ? It's about 5 seconds on google , or wven on this forum search engine ...

First search result ...

http://www.frihost.com/forums/search.php?mode=results

This topic:
http://www.frihost.com/forums/vt-94812.html&highlight=double+quotes


You will find the answer ...

And for futrure - try to search yourself ... the PHP programmer whi can't find such an easy answers will be ... well ... not good Smile

the PHP programmer who can't read/write will be ... well ... not good Wink

He was talking about double/single quotes in mysql, not php.

you can find the answer for the question here: http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html

Main difference is described in the first couple of lines
Quote:
If the ANSI_QUOTES SQL mode is enabled, string literals can be quoted only within single quotes because a string quoted within double quotes is interpreted as an identifier.


Besides that they are almost identical, and can be used when the other is part of the string or when the user likes to use them.
bernardnapoleon
thanks...

ps i tried searching it on google but i cant seem to find the right keywords to get an accurate answer from google.
Related topics
What is the difference between double and single quotes?
MySQL versions & providers!
Where to Learn the Correct Syntax for php
DID YOU KNOW????
Which sports you like?
php/mysql for pc use
With a gentle nudge, WLC refutes himself
Choice About Smartphone
Cannot insert data with single quote (Solved by Sonam)
Double-layer DVD
How To : Improve Your PHP Programming
Are u Single
SQL Server 2000 and MYSQL, pls help me.
A PHP problem !
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.