NOT NULL a lot when creating columns.
Is there a way to make this default when defining columns? In other words, make column
is_nullable default to
NO. (I realize this would make it harder for me to set it to
YES later one.)
closed as unclear what you're asking by Mark Storey-Smith, Paul White, Kin, RolandoMySQLDBA, dezso Aug 4 '13 at 6:42
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
YOU have to define NOT NULL when creating a table as described in documentation :
NOT NULL ==> The column is not allowed to contain null values.
Define two NOT NULL column constraints on the table distributors, one of which is explicitly given a name: