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
Which sports you like?
How To : Improve Your PHP Programming
Are u Single
SQL Server 2000 and MYSQL, pls help me.
A PHP problem !
MySQL versions & providers!
DID YOU KNOW????
What is the difference between double and single quotes?
php/mysql for pc use
With a gentle nudge, WLC refutes himself
Cannot insert data with single quote (Solved by Sonam)
Choice About Smartphone
Where to Learn the Correct Syntax for php
Double-layer DVD
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.