Another Little MySQL Problem

[Tim Golden]

On 26/05/2010 23:24, Christian Heimes wrote:
>>  Actually, no.  The names of tables are not quoted in SQL.
>> One writes
>>
>> SELECT ID FROM mytable;
>>
>> not
>>
>> SELECT ID FROM "mytable";
>
> nit picking mode:
>
> Some RDBMS support case sensitive table names. You have to quote the
> table name if you using the feature. Yeah I know, it's pretty bad idea
> but it's possible.

Also -- at least in MSSQL -- if the table name contains spaces
(and probably certain other characters which I can't be bothered to
research at this moment).

TJG