Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

MYSQL回滚,当发生外键约束等错误时,会自动回滚吗?

WBOY
Release： 2016-06-23 13:32:34
Original
1528 people have browsed it

MYSQL回滚,当发生外键约束等错误时,会自动回滚吗?
是否需要自己手动判断外键,然后手动rollback?


回复讨论(解决方案)

什么叫 自动回滚？ 回滚 到哪里？
既然发生错误，正在执行的指令就什么都没做，所以也不存在回滚

当存在外键约束时也一样，并不存在主表成功子表失败或自表成功主表失败的情况，MySQL 会自行验证，只在都成功的情况下才会完成操作

所谓事务回滚并非 MySQL 的功能，而是用户的一种需求。mysql 只是提供一个容器，来帮助用户实现

Related labels：
MYSQL回滚 当发生外键约束等错误时 会自动回滚吗?
source：php.cn
Previous article：刚刚看了几个推荐框架的帖子，蛮多推荐codeigniter的，请恕我直言，那框架实在不敢恭维啊~个人意见，仅供参考。 Next article：$.post('index.php?act=q&openid=<?php echo $openid;?>',{'qnumber':qNumber},functi
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Mysql returns some records as empty in date field because date has multiple formats I am trying to analyze order_date column and the column has multiple date formats and I wa...
From 2024-04-06 13:29:40
0
1
466
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
Content overflow in window prevents scrolling and hides new content I'm currently building a roulette system program (this is more to stop me from placing bet...
From 2024-04-03 21:24:55
0
1
285
How can I connect to a table and display its contents? (MySQL and PHP) I have two mysql tables (product and category). I have some mock data in both tables. Now ...
From 2024-04-03 09:55:31
0
1
350
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template