-- 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           ...