Here existing engine will be changed to MyISAM
ALTER TABLE student ENGINE = MyISAM;Here table students will be changed to student
ALTER TABLE students RENAME TO student;Here column name will be changed to first_name
ALTER TABLE student CHANGE COLUMN name first_name VARCHAR(45);
Comments 0