MySQL: Does the default value checked by the `CHECK` constraint?
0
votes
1
answer
227
views
Say I have the following schema, would the default value
https://sample.com
be checked by the CHECK (Website LIKE "https://% ")
?
CREATE TABLE Company (
AccountID varchar(25),
Name varchar(20) NOT NULL,
Website varchar(255) DEFAULT 'https://sample.com ',
Categories varchar(255) NOT NULL
DEFAULT '[]',
PRIMARY KEY(AccountID),
CHECK (CHAR_LENGTH(AccountID) BETWEEN 4 AND 25),
CHECK (CHAR_LENGTH(Name) BETWEEN 2 AND 20),
CHECK (Website LIKE "https://% ")
);
Asked by Rainning
(131 rep)
Apr 21, 2021, 07:03 AM
Last activity: Jun 9, 2025, 03:03 AM
Last activity: Jun 9, 2025, 03:03 AM