DEFAULT(col_name) : DEFAULT « Miscellaneous Functions « MySQL Tutorial






Returns the default value for a table column.

UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100;
22.2.DEFAULT
22.2.1.DEFAULT(col_name)