Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL - Default Column Value

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


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.

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.