是否可以在Azure数据库中为MySQL创建MyISAM表? [英] Creating MyISAM Table in Azure database for MySQL is enable?

问题描述

当我在Azure数据库中为Mysql创建该引擎为MyISAM的表时，出现错误错误1030(HY000):从存储引擎获得错误1"​​

When I create table that engine is MyISAM in Azure database for Mysql, Got Error "ERROR 1030 (HY000): Got error 1 from storage engine"

我该如何解决? 还是可以在Azure数据库中为MySQL使用MyISAM表?

How do I fix it? or can I use MyISAM table in Azure database for MySQL?

推荐答案

正确-Azure的MySQL数据库不支持MYISAM，主要是因为缺少事务支持，这可能会导致数据丢失.这是MySQL默认切换到InnoDB的原因之一.

Correct - MYISAM is not supported in Azure Database for MySQL, primarily due to the lack of transaction support which can potentially lead to data loss. This is one of the reasons MySQL switched over to InnoDB as the default.

杰森 Azure DB for MySQL团队

Jason Azure DB for MySQL team

这篇关于是否可以在Azure数据库中为MySQL创建MyISAM表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！