Change Column to (NOT) NULL

-- change column FIELD in table TABNAME to not nullable
ALTER TABLE TABNAME MODIFY FIELD NOT NULL;
DESC TABNAME
FIELD  NOT NULL ...

-- change column FIELD in table TABNAME to nullable
ALTER TABLE TABNAME MODIFY FIELD NULL;
DESC TABNAME
FIELD           ...