Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MYSQL error

Options
  • 25-04-2005 2:36pm
    #1
    al.
    Registered Users Posts: 78 ✭✭


    Whats wrong with this?Keeps giving me an error:

    ERROR 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 'Match
    (
    m_id VARCHAR(10),
    sport VARCHAR(10),
    comp VARCHAR(20),

    This is my table:

    Create Table Match
    (
    m_id VARCHAR(10),
    sport VARCHAR(10),
    comp VARCHAR(20),
    teams VARCHAR(20),
    date DATE,
    time TIME,

    Primary Key(m_id)
    );


Comments

  • Options
    #2
    Caixa
    Closed Accounts Posts: 36 ✭Caixa


    Match is a reserved word, if I remember correctly. Try calling the table something else.


  • Options
    #3
    al.
    Registered Users Posts: 78 ✭✭al.


    Thanks a lot,that worked...


Advertisement