hi i'm using innodb tables in my mqsql database and was wondering if there is anyway like in oracle to check to see if the constraints are working? also how can I make sure that a certain customer can only register once? does mysql support the UNIQUE function? and how would it be coded into a mysql table? Many thanks!