How to restrict user to input values within a range?

Question

I am new to MySQL, I want to restrict the row to only accept values from 1 to 1000 (inclusive)

CREATE TABLE Company(
    ID int NOT NULL,
    Name varchar(100),
    Employees int
);

this is the table and I need to restrict the ID row to only have values between 1 to 1000.

I need an updated solution. Thanks in Advance

Slava Rozhnev · Accepted Answer · 2020-11-22 13:37:02Z

2

Since MySQL 8.0 you can use CHECK constraint in table creation statement like:

CREATE TABLE Company (
  ID int NOT NULL  CHECK (ID BETWEEN 1 AND 1000), 
  Name varchar(100), 
  Employees int
);

answered Nov 22, 2020 at 13:29

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

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

1 Answer 1