Alter command to change MySQL table engine, table name and column name

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);

/25

Comment

About Author

Mohammad Towhidul Islam