Home / General Questions / Question No: 17

I'm looking for using FIELD CONSTRAINTS on MySQL but I can´t find it ... Doesn´t MySQL implement it? For example: age int > 0

MySQL doesn't support declarative CHECK CONSTRAINTs, you could use triggers as a workaround. However, you can do those checks with triggers. If a BEFORE trigger fails, the operation on the corresponding row is not performed. For more detail you may visit: http://dev.mysql.com/doc/refman/5.0/en/triggers.html