Adding constraint to an existing table column
To alter ypour existing table use

ALTER TABLE SomeTable 
ADD CONSTRAINT `Student_type2` CHECK (Type IN 
('Exchange-Student','Independent student','program Student'))


Or ad following to the CREATE TABLE seperated by comma

CONSTRAINT `Student_type2` CHECK (Type IN 
('Exchange-Student','Independent student','program Student')