Sorry, wrong example For instance, it makes no difference regarding the values I can enter if I declare a field as int or int(3)
On 1/5/07 1:52 PM, "Olaf Stein" <[EMAIL PROTECTED]> wrote: > 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] > ------------------------- 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]
