Re: QueryBrowser do not allow "..."

Kim,

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

"If the server SQL mode has ANSI_QUOTES enabled, string literals can be 
quoted only with single quotes. A string quoted with double quotes is 
interpreted as an identifier."

Best regards,
Mike

Kim G. Pedersen wrote:
> Hi
> Just try a
> Select ... where factorydate< UNIX_TIMESTAMP("2005-07-06")
> failing with an error :
> unknow column '2005-07-06' in where clause  errorno 1054
>
> But will only accept
> Select ... where factorydate< UNIX_TIMESTAMP('2005-07-06')
>
> " and ' ,,, should that not be the same ??
>
> Best Regards
>
> Kim G. Pedersen
> macaos/elprint R&D
> +45 35373808
> +45 20464108 (Cell)

--
Michael Zinner, GUI Developer
MySQL AB, www.mysql.com
Office: +43 676 753 26 30

Are you MySQL certified?  www.mysql.com/certification

--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@xxxxxxxxxxx