Re: Newbie with a Syntax error

[Dmitry Tolpeko]

Matt,

Also note that although MySQL parses CHECK constraints, it ignores them, so you need a trigger to enforce:

CHECK (supervisor>1000 AND supervisor<2000), 
id INT PRIMARY KEY CHECK (id>1000 AND id<3000));

Dmitry

--
http://www.sqlines.com - Database migration tools for SQL Server, Oracle and MySQL