Sample Header Ad - 728x90

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