MySql : set column value by using operators [duplicate]

Question

I have table in MySql database want to limit some column value,

is it possible to make a column in table to take specified value such as (value <= 3) ?

HijenHEK · Accepted Answer · 2021-05-21 19:01:37Z

1

you need to use a constraint named check which will be defined on table creation and check the value before insert .

CREATE TABLE table_name (          
    value INT ,
    CHECK(value <= 3)
)

answered May 21, 2021 at 19:01

HijenHEK

1,3061 gold badge6 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1