如何查看和修改mysql数据表引擎
super
2021-03-15 18:17
![views](/static/super/images/icon/evaluate-9a.png)
查看mysql数据表引擎
1)命令行查看
show create table table_name;
table_name 为数据表表名
![](/uploads/article/20210315/2f049060499ca20dcf0e8564b4b6a653.png)
2)Navicat查看
![](/uploads/article/20210315/28b5e89522dacff549de579658d44f28.png)
![](/uploads/article/20210315/5e2fb2a53c82bab627dc5e281bc6ba9c.png)
修改mysql数据表引擎
alter table table_name engine=InnoDB;
table_name 为数据表表名
![](/uploads/article/20210315/9d978a4bd33f7c3cb17afff26a9bb4d4.png)
0 条讨论