The storage engine used by MYSQL to view and modify tables

The correct method for MYSQL to view and modify the storage engine used by the table is: show table status from db_name where name = 'table _ name '; + ------ + -------- + --------- + ------------ + ------ + ---------------- + ------------- + signature + | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | + --------- + ------------ + ---------------- + ------------- + ----------------- + ------------ + | t | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | + ------ + -------- + --------- + ------------ + ------ + ---------------- + ------------- + ----------------- + www.2cto.com incorrect method: show create table table_name; + ------- + tables + | Table | Create Table | + ------- + tables + | t | create table 'T '( 'Vc 'varchar (1) default null, 'C' char (1) default null, KEY 'C' ('C ')) ENGINE = InnoDB default charset = utf8 | + ------- + engines + If mysqld does not start the corresponding ENGINE, such as InnoDB, the default myisam engine is used, so it is inaccurate. Modify: www.2cto.com alter table table_name engine = innodb; alter table table_name engine = myisam;