Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    21

    Unhappy Unanswered: tablename "group"

    How do I deal with a table named "group" in de MYSQL query?

    Or is it not permitted to use reserved names as tablenames? Or fieldnames...

    Thanks in advance.

    Niels

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: tablename "group"

    Originally posted by Niels
    How do I deal with a table named "group" in de MYSQL query?

    Or is it not permitted to use reserved names as tablenames? Or fieldnames...

    Thanks in advance.

    Niels
    Specify the column name (or table name or whatever) enclosed with backticks e.g.

    CREATE TABLE `group` (
    ID CHAR(13) NOT NULL,
    createdByID CHAR(13) NOT NULL,
    `read` CHAR(1) NULL,
    PRIMARY KEY (ID)
    )

    Hope this helps.

Posting Permissions

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