MySQL View modify storage engine

The first way:

The second way:

When creating a table, you can set up the storage engine for the new table by adding the engine keyword. For example

CREATE TABLE YXM (

ID bigint (a) NOT NULL auto_increment,

Name Char (20)

) Engine=myisam DEFAULT charset= GBK;

Dolly Mix

CREATE TABLE YXM1 (

ID bigint (a) NOT NULL auto_increment,

Name Char (20)

) Engine=innodb DEFAULT charset= GBK;

modifying engine engines for existing tables

ALTER TABLE YXM engine = InnoDB;

View the engine of the table, you can use show create table YXM \g;

MySQL View modify storage engine