From: Dan Nelson
Date: February 26 2007 6:17am
Subject: Re: using contraints on Mysql
List-Archive: http://lists.mysql.com/mysql/205228
Message-Id: <20070226061742.GB71962@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

In the last episode (Feb 25), Raúl Andrés Duque Murillo said:
>   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

You can do those checks with triggers:

http://dev.mysql.com/doc/refman/5.0/en/triggers.html

  # If a BEFORE trigger fails, the operation on the corresponding row
    is not performed.

-- 
	Dan Nelson
	dnelson@stripped