Is there a reason to specify DEFAULT (NULL) on a nullable column?

There is no need to add a DEFAULT(NULL) to nullable columns.

If data is not supplied to such columns, they will have a NULL.

The only benefit I see is the one Larry Lustig has posted in his comment to the question – it documents the fact that you have not forgotten to add a default to the nullable column.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)