correction on first one ALTER TABLE tableName MODIFY (Number int(6) NOT NULL );