What am I doing wrong?

Discussion in 'MySQL' started by lv211, Dec 19, 2007.

0
  1. #1
    I'm trying to create a table. Something is messed up and I can't figure it out. Here's the code and the error.

    CREATE TABLE vintage(
    'Region' varchar( 50 ) NOT NULL ,
    PRIMARY KEY ( Region )
    );

    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Region' varchar(50) NOT NULL,
    PRIMARY KEY ( Region )
    );' at line 2
     
    lv211, Dec 19, 2007 IP
  2. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Just drop the quotes around the column name.

    CREATE TABLE Vintage (Region varchar(50) NOT NULL, PRIMARY KEY (Region) );

    should work for you.
     
    Petey, Dec 19, 2007 IP
  3. lv211

    lv211 Peon

    Messages:
    168
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    It worked.

    Thanks.
     
    lv211, Dec 19, 2007 IP
  4. Yoseo

    Yoseo Guest

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yes i think this

    REATE TABLE Vintage (Region varchar(50) NOT NULL, PRIMARY KEY (Region) ); this in the php sistem by SLQ
     
    Yoseo, Dec 19, 2007 IP
  5. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    #5
    what does this mean?
     
    kishore415, Dec 19, 2007 IP
  6. kendo1979

    kendo1979 Peon

    Messages:
    208
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    i think the sentence was misspelled only
     
    kendo1979, Dec 30, 2007 IP