开发者社区> 问答> 正文

What are Transaction Storage Engines in MySQL?

已解决

What are Transaction Storage Engines in MySQL?

展开
收起
1780169608831412 2021-10-16 16:52:56 479 0
2 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。
    采纳回答

    To be able to use MySQL’s transaction facility, you have to be using MySQL’s InnoDB storage engine (which is the default from version 5.5 onward). If you are not sure which version of MySQL your code will be running on, rather than assuming InnoDB is the default engine you can force its use when creating a table, as follows

    2021-10-16 17:30:49
    赞同 1 展开评论 打赏
  • Transaction is the smallest non separable unit of work; Usually, a transaction corresponds to a complete business. At the SQL level, it can be understood as a transaction, which is a community composed of multiple SQL to complete a business function. The transaction affects the crud and other operations of SQL

    2021-10-16 17:27:09
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
One Box: 解读事务与分析一体化数据库 HybridDB for MySQL 立即下载
One Box:解读事务与分析一体化数据库HybridDB for MySQL 立即下载
如何支撑HTAP场景-HybridDB for MySQL系统架构和技术演进 立即下载

相关镜像