MariaDB DEFAULT Keyword
The MariaDB DEFAULT keyword is a constraint and it is used to set the default value for a column. The column takes default value when a new record is inserted without specifying any value.
MariaDB DEFAULT constraint with CREATE TABLE
The below mentioned statement creates a table called Employee which contains five columns: EmpID, Name, City, Age and Salary in which DEFAULT constraint is applied on column City.
CREATE TABLE Employee ( EmpID INT NOT NULL, Name VARCHAR(255), City VARCHAR(100) DEFAULT 'London', Age INT, Salary DECIMAL(18,2) );
The DEFAULT constraint can also be used to insert system values, by using functions like CURRENT_TIMESTAMP:
CREATE TABLE Orders ( OrderID INT NOT NULL, OrderQuantity INT NOT NULL, OrderPrice DECIMAL(18,2), OrderDate DATETIME DEFAULT CURRENT_TIMESTAMP );
MariaDB DEFAULT constraint with ALTER TABLE
In the above example, a table called Employee is created. To enforce DEFAULT constraint on City column, the statement is given below:
ALTER TABLE Employee ALTER City SET DEFAULT 'London'; OR ALTER TABLE Employee ALTER COLUMN City SET DEFAULT 'London';
DROP DEFAULT constraint
To drop DEFAULT constraint from table called Employee, the statement is given below:
ALTER TABLE Employee ALTER City DROP DEFAULT; OR ALTER TABLE Employee ALTER COLUMN City DROP DEFAULT;
❮ MariaDB Keywords