UPDATE my_table SET my_col_1 = DEFAULT(my_col_1), my_field = DEFAULT(my_field) WHERE id = 123
MariaDB DEFAULT column VALUE
How to retrieve default column value ? Simply using the miscellaneous DEFAULT(col_name) function.
How to retrieve default column value ? Simply using the miscellaneous DEFAULT(col_name) function.
UPDATE my_table SET my_col_1 = DEFAULT(my_col_1), my_field = DEFAULT(my_field) WHERE id = 123