DEFAULT(col_name)

Mengembalikan nilai default untuk kolom tabel. Kesalahan terjadi jika kolom tidak memiliki nilai default.

Syntax

MYSQL Copy

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

Contoh

Example

The use of DEFAULT(col_name) to specify the default value for a named column is permitted only for columns that have a literal default value, not for columns that have an expression default value.

MYSQL Copy

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