I've got some fairly simple problem but can't get it to work. mySQL allows to define constraints on table rows with a check condition. What I've been trying some time now is the following simple SQL-statement:
CREATE TABLE numbers (no INT NOT NULL CONSTRAINT con_pos CHECK no >= 0);
When I try to execute this I get an syntax error message. Maybe it's some really stupid question, but could please somebody clear this up for me.
Cheers & thx,
-- planning is the substitution of hazard by error --