Latest news
Home » Database » change the database engine of a MySQL database table?

change the database engine of a MySQL database table?

Different databse engines can use for database tables. Database engines are different in architecture.

Some occasions demands the db engine change  of table.

Usually tables are creating in MyISAM storage engine

InnoDB is the another option.It has advantages over MyISAM. InnoDB gives more importance to relational schema.

We can do it easily by mysql query

Take phpmyadmin

click on the database

click on sql tab

then execute the following sql statement.

ALTER TABLE your-table-name ENGINE = InnoDB;

example: ALTER TABLE  smarttips_user ENGINE = InnoDB;

Leave a Reply