Posted by Andy Hassall on 07/16/07 00:59

On Sun, 15 Jul 2007 20:31:54 -0400, Jerry Stuckle <jstucklex@attglobal.net>
wrote:

>> You should use single quotes for strings in SQL, not double quotes. Double
>> quotes are supposed to be for quoting table and column names ("identifiers").
>> MySQL can, in some cases, accept either, but you should stick with the right
>> one to avoid potential trouble, and to stay closer to standard SQL conventions.
>
>No back ticks are for quoting table and column names. Double quotes are
>a non-standard MySQL extension to the spec (and will fail if MySQl is
>running in strict ANSII SQL mode).

Other way around. Backticks are a non-standard MySQL extension. The standard
is double quotes.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

• Next in forum: Re: Question about reading data I've created with , delimiter
• Prev in forum: Re: Question about reading data I've created with , delimiter
• Thread view: Re: How do I escape parentheses in a mysql query?

[Reply to this message]