Use of transactions - Django, SQL tools

Third party modules need to be installed when using

pip install django-haystack whoosh jieba -i https://pypi.python.org/simple/            

#  Lock 
from django.db import transaction
#  Open transaction 
with transaction.atomic():
    #  Add rollback 
    point = transaction.savepoint()
    try:
        User.objects.filter(name='zhangsan').update(name='wangwu')
    except Exception as e:
        print(e)
        #  Rollback when the modification fails 
        transaction.savepoint_rollback(point)
        #  Submit after success 
    transaction.savepoint_commit(point)

sql The command line in

select @@global.transaction_isolation;    Look at the big picture 

select @@transaction_isolation;   View the current 

set session transaction isolation level serializable;    Serializable 

 Open transaction 
mysql> start transaction;


 end 
commit

link : https://pan.baidu.com/s/1WW8TF1PnOBZPHAK8N_uJMw?pwd=tvu5

Extraction code : tvu5

Copy the content and open Baidu disk , It is more convenient to operate

full name （Name）：cr173

Serial number （Code）：8d8120df-a5c3-4989-8f47-5afc79c56e7c Change Password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

# 6.SQLyog Be overdue , How to decode
I'm using SQLyog 9.63, There's only a one month probation period , How to exceed the probation period , What do I do ？
At this time, I can tell you a solution , That is by deleting the registry key , Get another month's probation . The specific operation method is as follows :
  First step , Enter... In the run window regedit, Enter to enter the registry editor .
  The second step , By path HKEY_CURRENT_USER->SoftWare Find the one marked in red {8E919370-*} term .

## The third step , Right click the item , Choose Delete , Click Yes again .