View Single Post

   
  #5 (permalink)  
Old 02-28-2008, 11:29 AM
ZeldorBlat
 
Posts: n/a
Default Re: Preventing Negative values in table.

On Oct 31, 8:22 pm, Michael Fesser <neti...@gmx.de> wrote:
>
> Your application should catch that, not the DB. Don't let your users
> submit such values.
>


Indeed it should, but I would never rely on the UI alone to enforce
data integrity. Unfortunately I don't think MySQL has check
constraints. Triggers are probably the next best thing.


Reply With Quote