Skip navigation links

MySQL Forums :: Database Design & Data Modelling :: Do we consider input validation when designing?


Advanced Search

Re: Do we consider input validation when designing?
Posted by: Peter Brawley ()
Date: August 24, 2010 11:37AM

Unfortunately MySQL does not support CHECK CONSTRAINT, and we have no indication from Oracle that MySQL ever will. Your alternatives are to fake it (see "Workarounds for absence of CHECK CONSTRAINT" at http://www.artfulsoftware.com/infotree/mysqltips.php) or code it in the app (always somewhat unsatisfactory).

PB
http://www.artfulsoftware.com

Options: ReplyQuote


Subject Written By Posted
Do we consider input validation when designing? wayne r 08/23/2010 02:48PM
Re: Do we consider input validation when designing? Peter Brawley 08/24/2010 11:37AM
Re: Do we consider input validation when designing? wayne r 08/24/2010 12:53PM
Re: Do we consider input validation when designing? Peter Brawley 08/24/2010 05:19PM
Re: Do we consider input validation when designing? wayne r 08/26/2010 12:19PM
Re: Do we consider input validation when designing? Rick James 08/27/2010 10:36PM
Re: Do we consider input validation when designing? wayne r 08/30/2010 11:49AM
Re: Do we consider input validation when designing? Peter Brawley 08/30/2010 12:44PM
Re: Do we consider input validation when designing? wayne r 08/30/2010 11:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.