For limiting possible values to 0, 1, 2, 3, 4, 5 you could use an ENUM, although that is not advised because you're using numeric indices to refer to numeric values and that can be confusing.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Olaf Stein [mailto:[EMAIL PROTECTED] > Sent: Friday, January 05, 2007 1:52 PM > To: [EMAIL PROTECTED] > Cc: MySql > Subject: Re: Varchar limit warning - similar question > > Thanks > That works nicely. > > Why does that not have any effect with numeric values. > E.g. I can insert the same max numbers in a tinyint column then in a > tinyint(1) column, > > For example, how do I create a column that only allows 1 > numeric value from > 0 to 5? > > Thanks > Olaf > > > On 1/5/07 12:52 PM, "[EMAIL PROTECTED]" > <[EMAIL PROTECTED]> wrote: > > > > > You need to set the sql_mode to STRICT_TRANS_TABLES or > STRICT_ALL_TABLES. We > > set this for the server in the my.cnf file. Be careful, > though, because there > > are some third-party GUI clients that don't read the > my.cnf file and thus > > don't set the sql_mode to what you expect. In that case, > set it yourself in > > the client: > > > > set SESSION sql_mode='STRICT_TRANS_TABLES'; > > select @@session.sql_mode; > > > > You can read about sql_mode here. > > > > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html > > > > Donna > > > > > > Olaf Stein <[EMAIL PROTECTED]> 01/05/2007 12:37 PM > > To > > MySql <[email protected]> > > cc > > Subject > > Varchar limit warning > > > > > > > > > > Hi all > > > > If I insert a value to great for a field (e.g. '123456' > into a varchar(5) > > field), mysql runs the insert without warning or error and > cuts of what > > doesn't fit. > > > > How can I tell it to launch an error and abort the insert? > > > > Thanks > > Olaf > > > > > ------------------------- > Olaf Stein > DBA > Center for Quantitative and Computational Biology > Columbus Children's Research Institute > 700 Children's Drive > phone: 1-614-355-5685 > cell: 1-614-843-0432 > email: [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
