Reset MySQL field to default value

Question

Is there a command in MySQL to reset a field to its default value? You know, in favor of the "Do Not Repeat Yourself" rule, I don't want to write the (quite long) default value multiple times in code, only once in the DB.

I looked around quite some time in google, found nothing. I'm starting to suspect such command doesn't exist, but nevertheless, if it does, sy here's going to know about it. :)

Answer 1

MySQL has a DEFAULT keyword (and function) that will do exactly what you want.

UPDATE table SET col = DEFAULT WHERE id = 2

OR

UPDATE table SET col = DEFAULT(col2) WHERE id = 3