Professional Web Applications Themes

What is MySQL's field delimiter ?? - MySQL

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...

  1. #1

    Default What is MySQL's field delimiter ??

    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
    Stefano Del Furia Guest

  2. #2

    Default Re: What is MySQL's field delimiter ??

    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 ´

    Greetings
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Ruhnau Guest

  3. #3

    Default Re: What is MySQL's field delimiter ??

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

    In data Wed, 07 Dec 2005 21:03:29 +0100, Kai Ruhnau
    <kai.newsgrouptragetaschen.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 ´
    >
    > Greetings
    > Kai
    Stefano Del Furia Guest

  4. #4

    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.newsgrouptragetaschen.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 [url]http://en.wikipedia.org/wiki/Keyboard_layout[/url]

    Greetings
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Ruhnau Guest

  5. #5

    Default Re: What is MySQL's field delimiter ??

    > 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.

    --
    Martijn Tonies
    Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
    Server
    Upscene Productions
    [url]http://www.upscene.com[/url]
    Database development questions? Check the forum!
    [url]http://www.databasedevelopmentforum.com[/url]


    Martijn Tonies Guest

  6. #6

    Default Re: What is MySQL's field delimiter ??

    In data Wed, 07 Dec 2005 22:26:21 +0100, Martijn Tonies
    <m.toniesupscene.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
    Stefano Del Furia Guest

  7. #7

    Default Re: What is MySQL's field delimiter ??

    Stefano Del Furia wrote:
    > Where can i change MySQL'mode to ANSI ???
    It's doented in the manual. Read this page:
    [url]http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html[/url]

    Regards,
    Bill K.
    Bill Karwin Guest

  8. #8

    Default Re: What is MySQL's field delimiter ??

    "What is the ascii code ?"

    ` -- backtick is ASCII code 96

    [Alt+96]...





    PRS Guest

Similar Threads

  1. String to mysql date field
    By Noyb in forum PHP Development
    Replies: 3
    Last Post: May 16th, 09:59 PM
  2. Replies: 3
    Last Post: October 28th, 05:28 PM
  3. MySQL Date Field Help Needed
    By Ralph Freshour in forum PHP Development
    Replies: 2
    Last Post: September 1st, 02:49 AM
  4. Formatting a MySQL date field
    By Luke Ross in forum PHP Development
    Replies: 2
    Last Post: August 20th, 10:56 AM
  5. [PHP] INT Field in mysql display without .00
    By Adam Voigt in forum PHP Development
    Replies: 0
    Last Post: July 16th, 02:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139