Miscellaneous Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Miscellaneous Functions
  4. DEFAULT(col_name)
Returns the default value for a table column.

UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100;