Ispirer Website
Ispirer Capabilities - MySQL Migration
Free Trial
This article describes the column default values supported by MySQL 5.x and earlier.
Default | |
---|---|
Syntax | DEFAULT expression |
Description | The DEFAULT clause lets you specify a value to be assigned to the column if a subsequent INSERT statement omits a value for the column |
Allowed Expressions | The value must be a constant |
Not Allowed Expressions | Functions or expressions. BLOB and TEXT columns cannot be assigned a default value. |