Re: Newbie with a Syntax error
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
Subject
Written By
Posted
Re: Newbie with a Syntax error
April 11, 2013 04:38AM
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.