In data Wed, 07 Dec 2005 22:26:21 +0100, Martijn Tonies
<m.tonies@upscene.removethis.com> ha scritto:

>
>> i have a table that have some fields that have names with spaces.
>> I know that some databases use [] as delimiter but this don't works with
>
> Not "some", only on MS SQL Server and MS Access :-)
>
>> MySQL
>> What is MySQL's field delimiter ??
>
> The name delimiter is the back-tick: ` (on my keyboard, it's on the
> same key as the ~ , left of the "1").
>
> In MySQL ANSI mode, you can also use the SQL standard " as in:
> "name with spaces" instead of `name with spaces`
>
> In general, I would say: don't use them unless you have to.
>

Thanks a lot.
Where can i change MySQL'mode to ANSI ???
Thanks again
Stefano