当前位置：网站首页>MySQL--锁的奥秘--数据怎么锁
MySQL--锁的奥秘--数据怎么锁
2022-04-23 06:30:00 【梦江河梦】
先看表结构
有如下数据
实验开始
事务1
事务2
获取当前数据库锁占用信息
可以看出事务1和2表面上操作staffid索引和staffno索引，但实际上锁的是对应的主键索引记录
版权声明
本文为[梦江河梦]所创，转载请带上原文链接，感谢
https://blog.csdn.net/weixin_42002747/article/details/124075362
边栏推荐
- 常用Markdown语法学习
- C SVG path parser of xamarin version
- Double sided shader
- A series of articles, a summary of common vulnerabilities of Web penetration (continuously updated)
- strcat()、strcpy()、strcmp()、strlen()
- Houdini地形与流体解算(模拟泥石流)
- Expression related to month, year and day in SVG
- 内网渗透系列：内网隧道之icmptunnel（DhavalKapil师傅的）
- MySQL in window10 version does not work after setting remote access permission
- Simplify exporting to SVG data files and all images in SVG folder
猜你喜欢
SQL sorts string numbers
内网渗透系列：内网隧道之icmptunnel（jamesbarlow师傅的）
随笔（不定时更新）
如何展示您的数字作品集：来自创意招聘人员的建议
第四章 无形资产
C problem of marking the position of polygons surrounded by multiple rectangles
内网渗透系列：内网隧道之icmptunnel（DhavalKapil师傅的）
Sto with billing cross company inventory dump return
Simplify exporting to SVG data files and all images in SVG folder
Dictionary & lt; T1,T2＆gt; Sorting problem
随机推荐
Scrapy modifies the time in the statistics at the end of the crawler as the current system time
《内网安全攻防：渗透测试实战指南》读书笔记（四）：权限提升分析及防御
【Unity VFX】VFX特效入门笔记-火花制作
ABAP ALV显示金额与导出金额不一致
Reptile learning notes, learning reptile, read this article is enough
Learning records of some shooting ranges: sqli labs, upload labs, XSS
One of event management
C read INI file and write data to INI file
Nodejs (four) character reading
SQL user-defined scalar value function that looks up relevant column values n times forward or backward according to a specified table name, column name and column value
VBA调用SAP RFC实现数据读取＆写入
The problem of exporting excel form with wireframe and internal spacing of form by using web form
Chapter IV intangible assets
SAP自建表log功能开启
webflux文件上传下载
C＃控制相机，旋转，拖拽观察脚本(类似Scenes观察方式)
SAP TR手动导入系统操作手册
05数组的使用
Using lambda expression to solve the problem of C file name sorting (whether it is 100 or 11)
How does Apache Hudi accelerate traditional batch mode?