Mega Code Archive

 

Categories / MySQL Tutorial / Miscellaneous Functions

 

DEFAULT(col_name)

Returns the default value for a table column. UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100;