Newbie with a Syntax error
I am getting a syntax error on the last line of this Table statement. Using MySQL. If this is the wrong forum, please let me know:
CREATE TABLE Employees
(firstname VARCHAR(20),
lastname VARCHAR(20),
department VARCH.AR(20),
hiredate DATE,
supervisor INT CHECK (supervisor>1000 AND supervisor<2000),
id INT PRIMARY KEY CHECK (id>1000 AND id<3000));
Subject
Written By
Posted
Newbie with a Syntax error
April 09, 2013 08:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.