View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 08:12 AM
Kai Ruhnau
 
Posts: n/a
Default Re: What is MySQL's field delimiter ??

Stefano Del Furia wrote:
> In data Wed, 07 Dec 2005 21:03:29 +0100, Kai Ruhnau
> <kai.newsgroup@tragetaschen.dyndns.org> ha scritto:
>
>> Stefano Del Furia wrote:
>>
>>> Hi all,
>>> 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 MySQL
>>> What is MySQL's field delimiter ??
>>> Thanks in advance
>>> Stefano

>>
>>
>> It is a backtick:
>> `
>>
>> But do not mix it up with ', " or ยด
>>

> Thanks
> but how can i type it on keyboard ??
> what is the ascii code ?
> thank again
> Stefano


Please stop top posting.

It depends on your keyboard layout.

On the german keyborad it is shift-[first key left of backspace] and
mostly a deadkey. That means pressing it will not print it immediately.

A workaround is to press space right after pressing the key for `.

On an us keyboard layout it is the key left of 1 (one).

See http://en.wikipedia.org/wiki/Keyboard_layout

Greetings
Kai

--
This signature is left as an exercise for the reader.
Reply With Quote