MySQL - Default Column Value

This article describes the column default values supported by MySQL 5.x and earlier.

Overview

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.