Reputation: 2564
How to set varchar, text, int default to NULL in Mysql?
I have a table, some columns are optional for the user to fill.
I want to set the default to NULL if the user didn't fill any thing.
I try to do it in PHPMyAdmin, but I got error #1067 - Invalid default value
Upvotes: 5
Views: 6505