MySQL Database

MySQL Default

Provide a value automatically when an INSERT omits a column.

CREATE TABLE tasks (
  id INT PRIMARY KEY,
  status VARCHAR(20) DEFAULT 'pending'
);

The default applies to new rows and does not overwrite an explicitly supplied value.