database icon indicating copy to clipboard operation
database copied to clipboard

💡 MySQL: add supproting for `CHECK` constraint

Open roxblnfk opened this issue 3 years ago • 0 comments

I have an idea!

CREATE TABLE Customers
(
  Age INT DEFAULT 18 CHECK(Age >0 AND Age < 100),
)

Or

CREATE TABLE Customers
(
    Age INT DEFAULT 18,
    CHECK((Age >0 AND Age<100) AND (Email !='') AND (Phone !=''))
);

See

roxblnfk avatar Dec 21 '22 20:12 roxblnfk