Hello guy, today we will learn how to change the database engine in the table. This video basically changing MySQL database engine InnoDB to MEMORY. Topic: 1) How to get all database engines? 2) How to get current using a database engine? 3) How to change the database engine in the particular table? INFORMATION_SCHEMA that provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. A storage engine is a software module that a database management system uses to create, read, update data from a database. ... There are two types of storage engines in MySQL: transactional and non-transactional. For MySQL 5.5 and later, the default storage engine is InnoDB To change the database engine of a MySQL database table, go to your phpMyAdmin available in Site Tools. ... ALTER TABLE my_table ENGINE = InnoDB; If the query is executed properly, the database engine of the table will be changed to ...