When you know a thing, to hold that you know it, and when you do not know a thing, to allow that you do not know it - this is knowledge. -Confucius-

Thursday, April 4, 2013

SQL TRIGGERs

When we were doing a database project we faced to a little problem when we try to check some constraints on a table on insert , update, delete operations. There is a table called 'infos' and there is a column called age. The values of the age should be greater than 0. So to check that constraint we used SQL CHECK constrain. It appears to be accepted by mySQL as a valid one but when inserts happens we noticed that...