MySQL Workbench EER Diagramm-如何更改存储引擎? [英] MySQL Workbench EER Diagramm - how to change storage engine?

问题描述

我使用MySQL Workbench 5.2.38.而且我已经制作了一张EER图.但是在导出时，我对InnoDB作为定义的存储引擎感到惊讶.此后不能更改表，因为我没有InnoDB引擎.

I use MySQL Workbench 5.2.38. and I have made an EER Diagram. But on export I got surprised with InnoDB as defined storage engine. Altering the table afterwards is not an option because I do not have an InnoDB engine.

错误1286(42000):未知的存储引擎'InnoDB'

ERROR 1286 (42000): Unknown storage engine 'InnoDB'

因此，我已通过Edit-> Preferences-> Model:将MySQL更改为MyISAM，但在导出时，仍在使用InnoDB吗?！

So, I have changed the Default Engine via Edit-> Preferences -> Model: MySQL to MyISAM but on export there is still InnoDB in use?!

我完全无法在表编辑器中找到更改存储引擎的选项.有人可以帮我如何在MySQL Workbench ERR中更改表的存储引擎吗?

I am completely unable to find the option to change the storage engine in table editor. Can someone help me how I can change the storage engine for my tables in MySQL Workbench ERR?

推荐答案

它不是很明显，但是在编辑表格时，右侧有一个蓝色箭头.如果单击此按钮，则会获得更多选项，您可以在其中更改存储引擎.

It's not very obvious but when editing a table there is a blue arrow on the right. If you click this you get more options where you can alter the storage engine.

这篇关于MySQL Workbench EER Diagramm-如何更改存储引擎?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！