开发者社区 问答 正文

What are Transaction Storage Engines in MySQL?

已解决

What are Transaction Storage Engines in MySQL?

展开
收起
1780169608831412 2021-10-16 16:52:56 492 分享
分享
版权
举报
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 评论

    评论

    全部评论 (0)

    登录后可评论
  • 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 举报
    赞同 评论

    评论

    全部评论 (0)

    登录后可评论
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等