List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 26 2007 6:17am
Subject:Re: using contraints on Mysql
View as plain text  
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
Thread
using contraints on MysqlRaúl Andrés Duque Murillo26 Feb
  • Re: using contraints on MysqlDan Nelson26 Feb
  • Re: using contraints on MysqlMartijn Tonies26 Feb