How to set value range to a column in mysql?

I want to set a value range to a column of a table.

Example For the decimal decimal, This decimal column should allow to insert or update the value between开发者_如何学编程 0 to 30.

Thanks in advance...!

---

As MySQL still doesn't support check constraints, the only way to do this in MySQL is a trigger (for update and insert) that checks the new value of the column and throws an error if the value is outside the valid range.

---

look for ENUM and SET Constraints http://dev.mysql.com/doc/refman/5.6/en/constraint-enum.html