mysql DEFAULT constraint

UK[dɪˈfɔ:lt] US[dɪˈfɔlt]

vi. Failure to perform tasks or responsibilities; failure to appear in court when summoned; failure to appear in court; abstention

vt. Failure To perform, to default; to fail to participate or complete (e.g., a competition); [Law] to lose (lawsuit) by not appearing in court

n. To fail to perform, to default; [Law] to fail to appear in court; to abstain; [Plan ] Default, default

Third person singular: defaults Present participle: defaulting Past tense: defaulted Past participle: defaulted

mysql DEFAULT constraint syntax

Function:Used to insert default values into columns.

Note:If no other value is specified, the default value will be added to all new records.

mysql DEFAULT constraint example

//在 "Persons" 表创建时为 "City" 列创建 DEFAULT 约束 CREATE TABLE Persons(Id_P int NOT NULL,LastName varchar(255) NOT NULL,FirstName varchar(255),Address varchar(255),City varchar(255) DEFAULT 'Sandnes');