Re: QueryBrowser do not allow "..."
"Kim G. Pedersen" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Message-ID | <[email protected]> |
Hi Michael
Thanks for fast answer , but
It did clearify some of the problem , but why is
QueryBrowser the only tool /component which do complain.
I use Zeos Component / old MysqlCC - They have no problem.
Can it have something to do with the ClientLib I am using ??
1) zeos is running with libMysqlClient.so.10.0.0 on linux.
2) MysqlCC is running windows lastest version
Best regards
kim
> 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]
>
Best Regards
Kim G. Pedersen
macaos/elprint R&D
+45 35373808
+45 20464108 (Cell)
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/[email protected]