python 释放mysql的锁_python 多人连接mysql 进行事务操作 对mysql加锁与释放锁

python 多人连接mysql 对mysql进行事务操作 对mysql加锁与释放锁

下面这个是user1代码块

# -*- coding: utf-8 -*-

# user1

import pymysql

import time

conn = pymysql.connections.Connection(host="localhost", user='debian-sys-maint', password='wL5wsDKDub4gT2EU',

database='python3_1', port=3306, charset='utf8')

cusor_1 = conn.cursor()

sql = "update students set name='huanghaibo' where id=2"

cusor_1.execute(sql)

time.sleep(20)

print('awaken')

conn.commit()

cusor_1.close()

conn.close()

下面这个是user2代码块

# -*- coding: utf-8 -*-

#user2

import pymysql

import time

conn = pymysql.connections.Connection(host="localhost", user='debian-sys-maint', password='wL5wsDKDub4gT2EU&#