Shulou(Shulou.com)06/01 Report--

First, check the engine

1. View the mysql engine

one

SHOW ENGINES

2. View the table engine, method 1

SHOW TABLE STATUS from database name where Name=' table name'

one

SHOW TABLE STATUS from mytest where Name='test'

3. Check the table engine, method 2

Mysqlshow-u database login account-p 'database login account password'-- status database name table name

one

Mysqlshow-uroot-p123456-- status mytest test

II. Modification

1. Method 1

one

two

Alter table tt7 engine=innodb

Alter table tt7 engine=myisam

2. Method 2

1) create a table with the same table structure as tt7

one

Create table tt7_tmp like tt7

2) tt7_tmp as the intermediate result set

one

Insert into tt7_tmp select from tt7

3) Delete the data of the original table

one

Truncate table tt7

4) change the storage engine of the original table this time

one

Alter table tt7 engine=innodb

5) then import the data of the intermediate result set back to the original table

one

Insert into tt7 select from tt7_tmp

6) Delete the intermediate table

one

Drop table tt7_tmp

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.