[Mono-list] Cast a char(1) to a boolean

[Nick Loeve]

http://dev.mysql.com/doc/mysql/en/Legal_names.html

apparently u can use double quotes if you use the ANSI_QUOTES mode 
option:

SET sql_mode='ANSI_QUOTES';



On 25/10/2004, at 2:03 PM, Michael J. Ryan wrote:

> no, a double-quote sign... that's the ansi spec..
> "myschema"."mytable"  not `myschema`.`mytable`
>
> Nick Loeve wrote:
>> Not likely. '' Signifies a string.
>> On 25/10/2004, at 11:08 AM, Michael J. Ryan wrote:
>>> any chance, they'll start using " for wrapping table/column names
>>> instead of ` ... that would make me *very* happy.
>
> -- 
> Michael J. Ryan - tracker1(at)theroughnecks(dot)com - 
> www.theroughnecks.net
> icq: 4935386  -  AIM/AOL: azTracker1  -  Y!: azTracker1  -  MSN/Win: 
> (email)
>