MySql : set column value by using operators

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) ?

You can use `CHECK` constraints in MySQL 8.x. – Barmar May 21 '21 at 19:00 — Barmar, May 21 '21 at 19:00

score 1 · Accepted Answer · answered May 21 '21 at 19:01

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 '21 at 19:01

HijenHEK

1 Answers1