How to set value range to a column in mysql? -

-

i want set value range column of table.

example decimal decimal, decimal column should allow insert or update value between 0 30.

thanks in advance...!

as mysql still doesn't support check constraints, way in mysql trigger (for update , insert) checks new value of column , throws error if value outside valid range.


Comments

Post a Comment

Popular posts from this blog

haskell - Using filter on an item in a list? -

-
i trying filter item in list , print them line line. here's code: data car = car string [string] int [string] testdatabase :: [car] testdatabase = [car"casino royale" ["daniel craig"] 2006 ["garry", "dave", "zoe", "kevin", "emma"],car"blade runner" ["harrison ford", "rutger hauer"] 1982 ["dave", "zoe", "amy", "bill", "ian", "kevin", "emma", "sam", "megan"]] formatcarrow (car b c d) = show ++ " | " ++ concat [i ++ ", " | <- init b] ++ last b ++ " | " ++ show c ++ " | " ++ concat [j ++ ", " | j <- init d] ++ last d displayfilmsbyyear :: string -> io [()] displayfilmsbyyear chosenyear = mapm (putstrln.formatfilmrow) [putstrln(filter ((== chosenyear).y)) | (w x y z) <- testdatabase] -- code not working think why isnt work...
Read more

tomcat6 - Exception when stopping container for a with Spring + Quartz + Tomcat web application -

-
when stopping tomcat, getting following exception: ...appears have started thread named [ org.springframework.scheduling.quartz.schedulerfactorybean#0_worker-10 ] has failed stop it. create memory leak. how can prevent it? have destroy-method set destroy on schedulerfactorybean bean. just say... we have exactely same error grails (wich spring -based) & quartz on tomcat server... thread can't stopped quartz pool we've never managed correct that
Read more

c# - Binding attached property to IEnumerable -

-
i using new wpf viewer crystal reports in c#. using mvvm, bind source of data displayed instead of doing in loaded event. therefore, wanted implement attached property source - binding doesn't work, getter method not called. other posts binding attached properties didn't , not sure doing different. can help? here simplified code attached property: public static class crystalreportsattached { public static readonly dependencyproperty sourceproperty = dependencyproperty.registerattached( "source", typeof(ienumerable), typeof(crystalreportsattached), new uipropertymetadata(new observablelist<participant>() ienumerable, sourcechanged)); public static void setsource(dependencyobject target, ienumerable value) { target.setvalue(sourceproperty, value); } public static ienumerable getsource(dependencyobject target) { return (ienumerable)target.getvalue(sourceproperty); } ...
Read more