Results 1 to 2 of 2

Thread: Syntax error

  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Syntax error

    Hi, I'm just starting a web design course (basic) and have to create a database with 2 tables. I have done the the following on the first table, but come up with "syntax error in CREATE TABLE statement". Where have I gone wrong?

    CREATE TABLE Employee
    (
    EMP_ID int PRIMARY KEY,
    Location CHAR(255),
    FirstName CHAR(255),
    Surname CHAR(255);

    Do I have spaces where there shouldn't be, for example?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by tahiti_rose View Post
    Do I have spaces where there shouldn't be, for example?
    nope, the spaces are okay

    the parentheses aren't, however

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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