![](https://img.haomeiwen.com/i2013018/5b8c61f3acb26565.png)
![](https://img.haomeiwen.com/i2013018/0fc6f8d9a336e18f.png)
![](https://img.haomeiwen.com/i2013018/eef0c5182bf1ad0e.png)
![](https://img.haomeiwen.com/i2013018/e7f24b8b46d95c70.png)
![](https://img.haomeiwen.com/i2013018/8803a4accc448132.png)
经测试如下成功
![](https://img.haomeiwen.com/i2013018/32320b2f7fab2e9a.png)
![](https://img.haomeiwen.com/i2013018/75f456f3eff59b86.png)
![](https://img.haomeiwen.com/i2013018/40614de56a8c81ba.png)
实例
![](https://img.haomeiwen.com/i2013018/860c63e971074152.png)
![](https://img.haomeiwen.com/i2013018/0282369f59bfe798.png)
![](https://img.haomeiwen.com/i2013018/55b77bff7c59b88a.png)
![](https://img.haomeiwen.com/i2013018/107d16de6b237d16.png)
![](https://img.haomeiwen.com/i2013018/e0e4f33f8bf2bc38.png)
![](https://img.haomeiwen.com/i2013018/19ee567c30b3b7a0.png)
![](https://img.haomeiwen.com/i2013018/92cc33478b6d5951.png)
以下使用commit()三条sql语句就作为整体提交和执行了
![](https://img.haomeiwen.com/i2013018/d90436da2db2ef61.png)
一般会将要执行的操作放在try块里,然后异常时使用rollback()使结果变成没执行之前的样子。事务保证一组操作要么同时执行,要么同时不执行。
经测试如下成功
实例
以下使用commit()三条sql语句就作为整体提交和执行了
一般会将要执行的操作放在try块里,然后异常时使用rollback()使结果变成没执行之前的样子。事务保证一组操作要么同时执行,要么同时不执行。
本文标题:python 操作mysql
本文链接:https://www.haomeiwen.com/subject/fuexdttx.html
网友评论