mysql DEFAULT constraint
Translation results：
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 constraintsyntax
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 constraintexample
//在 "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');