Re: QueryBrowser do not allow "..."
"Michael G. Zinner" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Organization | MySQL AB |
| Message-ID | <[email protected]> |
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/[email protected]