Mysql当前读下解决幻读
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠==
Text Elements
事务A ^yULSUGNg
事务B ^RjMMNDeM
select * from orders where 10 < price and price < 30 for update; ^OsIsBHFw
insert into orders values('0', 0); ^63pCPtlL
begin; ^kDOu9ePb
begin; ^7fThy2SG
mysql> select * from orders where 10 < price and price < 30 for update;
Empty set (0.00 sec) ^hJz4O6N5
commit; ^MGW9pfDf
commit; ^jg59Mf7V
select * from orders where 10 < price and price < 30 for update; ^CUbXXgu0
Query OK, 1 row affected (0.01 sec) ^nRq6y28W
insert into orders values('2', 20); ^sVIbCQl3
block.... ^8wocq1Xv
mysql> insert into orders values('2', 20);
Query OK, 1 row affected (11.87 sec) ^v2qj8itZ
select * from orders; ^X4GPYVyI
mysql> select * from orders; ^ZBe0o3D7
+------+-------+ ^fH4SeFGn
| id | price | ^ZNWoA9Q4
+------+-------+ ^hg6gXFjs
| 1 | 10 | ^nBKxfUMA
| 3 | 30 | ^22FJUYZ1
+------+-------+ ^wZE9T6VK
2 rows in set (0.00 sec) ^6KY3c3Oq
select * from orders where 10 < price and price < 30 for update; ^4GNoVRub
mysql> select * from orders where 10 < price and price < 30 for update;
Empty set (0.00 sec) ^CAo486kJ
insert into orders values('4', 40); ^PYFHvKEp
Query OK, 1 row affected (0.01 sec) ^WtPGnNol
mysql> select * from orders where 10 < price and price < 30 for update; ^l0eH9j1q
+------+-------+ ^zZF77DOD
| id | price | ^EnIG3geb
+------+-------+ ^VTZ27i6A
| 2 | 20 | ^iFwg8Qmv
+------+-------+ ^WDffaa2t
1 row in set (0.00 sec) ^9RnqcOHx
%%
Drawing
{
"type": "excalidraw",
"version": 2,
"source": "https://excalidraw.com",
"elements": [
{
"type": "rectangle",
"version": 310,
"versionNonce": 1115883929,
"isDeleted": false,
"id": "GleKbBXFnMW_AvPBwxd_k",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -259.2399015017253,
"y": -602.5009960623119,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1818528537,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "yULSUGNg"
}
],
"updated": 1674396221721,
"link": null,
"locked": false
},
{
"type": "text",
"version": 256,
"versionNonce": 420667479,
"isDeleted": false,
"id": "yULSUGNg",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -160.73990150172529,
"y": -569.5009960623119,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 54,
"height": 29,
"seed": 1649413879,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396871681,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务A",
"rawText": "事务A",
"baseline": 21,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "GleKbBXFnMW_AvPBwxd_k",
"originalText": "事务A"
},
{
"type": "rectangle",
"version": 359,
"versionNonce": 1887465081,
"isDeleted": false,
"id": "mFMPNEGMTFRQsDp-pq8GO",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 73.32173242219824,
"y": -601.6545687227507,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 901103609,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "RjMMNDeM"
}
],
"updated": 1674396221721,
"link": null,
"locked": false
},
{
"type": "text",
"version": 307,
"versionNonce": 1581986969,
"isDeleted": false,
"id": "RjMMNDeM",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 170.82173242219824,
"y": -568.6545687227507,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 56,
"height": 29,
"seed": 2038503447,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396871684,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务B",
"rawText": "事务B",
"baseline": 21,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "mFMPNEGMTFRQsDp-pq8GO",
"originalText": "事务B"
},
{
"type": "rectangle",
"version": 204,
"versionNonce": 1195259737,
"isDeleted": false,
"id": "iigkfTVm-9Ee9GZ2iHXHZ",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -254.46393551262793,
"y": -379.332420399584,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 751655129,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "OsIsBHFw"
}
],
"updated": 1674396221721,
"link": null,
"locked": false
},
{
"type": "text",
"version": 218,
"versionNonce": 593511223,
"isDeleted": false,
"id": "OsIsBHFw",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -242.46393551262793,
"y": -371.332420399584,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 227,
"height": 75,
"seed": 1408498999,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397108211,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders \nwhere 10 < price and \nprice < 30 for update;",
"rawText": "select * from orders where 10 < price and price < 30 for update;",
"baseline": 68,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "iigkfTVm-9Ee9GZ2iHXHZ",
"originalText": "select * from orders where 10 < price and price < 30 for update;"
},
{
"type": "rectangle",
"version": 704,
"versionNonce": 1740311897,
"isDeleted": false,
"id": "gUbpz9hBGgCX6AU6yrePS",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 76.55843389588472,
"y": -275.42583255059594,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 84,
"seed": 322885049,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "63pCPtlL"
}
],
"updated": 1674397142187,
"link": null,
"locked": false
},
{
"type": "text",
"version": 695,
"versionNonce": 1868650519,
"isDeleted": false,
"id": "63pCPtlL",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 110.05843389588472,
"y": -258.42583255059594,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 184,
"height": 50,
"seed": 1695366743,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397147823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "insert into orders \nvalues('0', 0);",
"rawText": "insert into orders values('0', 0);",
"baseline": 43,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "gUbpz9hBGgCX6AU6yrePS",
"originalText": "insert into orders values('0', 0);"
},
{
"type": "rectangle",
"version": 249,
"versionNonce": 567866649,
"isDeleted": false,
"id": "wnXaZR0C-Uzfa3EzhsnQN",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -255.89384397421895,
"y": -489.3821923076806,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 741193369,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "kDOu9ePb"
}
],
"updated": 1674396221721,
"link": null,
"locked": false
},
{
"type": "text",
"version": 213,
"versionNonce": 1009730807,
"isDeleted": false,
"id": "kDOu9ePb",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -155.89384397421895,
"y": -456.3821923076806,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 25,
"seed": 1067539319,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "wnXaZR0C-Uzfa3EzhsnQN",
"originalText": "begin;"
},
{
"type": "rectangle",
"version": 334,
"versionNonce": 1426909689,
"isDeleted": false,
"id": "WQ8BK9okkr6yk_kNZ5VbR",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 76.85455155785985,
"y": -490.2747175483379,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 172850041,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "7fThy2SG"
}
],
"updated": 1674396221721,
"link": null,
"locked": false
},
{
"type": "text",
"version": 298,
"versionNonce": 2114555415,
"isDeleted": false,
"id": "7fThy2SG",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 176.85455155785985,
"y": -457.2747175483379,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 25,
"seed": 670356631,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "WQ8BK9okkr6yk_kNZ5VbR",
"originalText": "begin;"
},
{
"type": "text",
"version": 287,
"versionNonce": 120924281,
"isDeleted": false,
"id": "hJz4O6N5",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -872.4554534496447,
"y": -370.8176435088644,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 595,
"height": 41,
"seed": 501326937,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397121237,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)",
"rawText": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)",
"baseline": 35,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)"
},
{
"type": "rectangle",
"version": 555,
"versionNonce": 1942218937,
"isDeleted": false,
"id": "KuNr1MjXZrJOWPWSnv2tz",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -256.3281372623161,
"y": 19.73284196486145,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1706830263,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "4GNoVRub"
}
],
"updated": 1674397176124,
"link": null,
"locked": false
},
{
"type": "text",
"version": 94,
"versionNonce": 156687191,
"isDeleted": false,
"id": "4GNoVRub",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -244.3281372623161,
"y": 27.73284196486145,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 227,
"height": 75,
"seed": 34273015,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397176124,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders \nwhere 10 < price and \nprice < 30 for update;",
"rawText": "select * from orders where 10 < price and price < 30 for update;",
"baseline": 68,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "KuNr1MjXZrJOWPWSnv2tz",
"originalText": "select * from orders where 10 < price and price < 30 for update;"
},
{
"type": "rectangle",
"version": 613,
"versionNonce": 9988505,
"isDeleted": false,
"id": "phbJ5Xvqj0radu2Lg34u4",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -258.19371639718725,
"y": 134.0702620684724,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 239411737,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "MGW9pfDf"
}
],
"updated": 1674397176124,
"link": null,
"locked": false
},
{
"type": "text",
"version": 588,
"versionNonce": 1118787703,
"isDeleted": false,
"id": "MGW9pfDf",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -166.69371639718725,
"y": 167.0702620684724,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 25,
"seed": 1034446839,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397176124,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "phbJ5Xvqj0radu2Lg34u4",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 975,
"versionNonce": 82431609,
"isDeleted": false,
"id": "F1lHLW6PewovpYzBmzXy_",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 73.75566515780213,
"y": 256.61319780011536,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 493582073,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "jg59Mf7V"
}
],
"updated": 1674397176124,
"link": null,
"locked": false
},
{
"type": "text",
"version": 949,
"versionNonce": 1916481943,
"isDeleted": false,
"id": "jg59Mf7V",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 165.25566515780213,
"y": 289.61319780011536,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 25,
"seed": 1516654871,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397176124,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "F1lHLW6PewovpYzBmzXy_",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 813,
"versionNonce": 1733564247,
"isDeleted": false,
"id": "8Wht4Bh3D7avwZn4BZ5fO",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -248.19333758738708,
"y": 370.8727632547625,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 582234073,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "CUbXXgu0"
}
],
"updated": 1674397221287,
"link": null,
"locked": false
},
{
"type": "text",
"version": 777,
"versionNonce": 655977879,
"isDeleted": false,
"id": "CUbXXgu0",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -236.19333758738708,
"y": 378.8727632547625,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 227,
"height": 75,
"seed": 902436407,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397222133,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders \nwhere 10 < price and \nprice < 30 for update;",
"rawText": "select * from orders where 10 < price and price < 30 for update;",
"baseline": 68,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "8Wht4Bh3D7avwZn4BZ5fO",
"originalText": "select * from orders where 10 < price and price < 30 for update;"
},
{
"type": "text",
"version": 41,
"versionNonce": 1697471289,
"isDeleted": false,
"id": "nRq6y28W",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 380.2675643310665,
"y": -265.72317596545054,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 357,
"height": 25,
"seed": 1220127255,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "Query OK, 1 row affected (0.01 sec)",
"rawText": "Query OK, 1 row affected (0.01 sec)",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "Query OK, 1 row affected (0.01 sec)"
},
{
"type": "rectangle",
"version": 868,
"versionNonce": 1238884089,
"isDeleted": false,
"id": "2wRhe5lhfh-XQ1qgxbLBv",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 79.18555388850609,
"y": -80.50536151263339,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 84,
"seed": 1544386743,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "sVIbCQl3"
}
],
"updated": 1674397188977,
"link": null,
"locked": false
},
{
"type": "text",
"version": 857,
"versionNonce": 1491606137,
"isDeleted": false,
"id": "sVIbCQl3",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 112.68555388850609,
"y": -63.505361512633385,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 184,
"height": 50,
"seed": 1345114681,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397196095,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "insert into orders \nvalues('2', 20);",
"rawText": "insert into orders values('2', 20);",
"baseline": 43,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "2wRhe5lhfh-XQ1qgxbLBv",
"originalText": "insert into orders values('2', 20);"
},
{
"type": "text",
"version": 251,
"versionNonce": 2050905369,
"isDeleted": false,
"id": "8wocq1Xv",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 378.443223510754,
"y": -74.74048419329733,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 69,
"height": 25,
"seed": 704672791,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397176124,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "block....",
"rawText": "block....",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "block...."
},
{
"type": "arrow",
"version": 322,
"versionNonce": 270267705,
"isDeleted": false,
"id": "QCIa3qeRyK4A74iU_rdvx",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 358.77931359864465,
"y": -43.542554810973115,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 0.22943670099425617,
"height": 296.8023612282493,
"seed": 1365961401,
"groupIds": [],
"roundness": {
"type": 2
},
"boundElements": [],
"updated": 1674397203586,
"link": null,
"locked": false,
"startBinding": null,
"endBinding": null,
"lastCommittedPoint": null,
"startArrowhead": null,
"endArrowhead": "arrow",
"points": [
[
0,
0
],
[
0.22943670099425617,
296.8023612282493
]
]
},
{
"type": "text",
"version": 390,
"versionNonce": 931733079,
"isDeleted": false,
"id": "v2qj8itZ",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 388.98005327493456,
"y": 226.8009489022951,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 402,
"height": 50,
"seed": 1652843321,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397213308,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "mysql> insert into orders values('2', 20);\nQuery OK, 1 row affected (11.87 sec)",
"rawText": "mysql> insert into orders values('2', 20);\nQuery OK, 1 row affected (11.87 sec)",
"baseline": 43,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> insert into orders values('2', 20);\nQuery OK, 1 row affected (11.87 sec)"
},
{
"type": "rectangle",
"version": 294,
"versionNonce": 652880505,
"isDeleted": false,
"id": "wZReN7-9szlRYBuKEJmoC",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -262.7339986021227,
"y": -710.6404129245454,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 947809527,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "X4GPYVyI"
}
],
"updated": 1674396285614,
"link": null,
"locked": false
},
{
"type": "text",
"version": 309,
"versionNonce": 586268375,
"isDeleted": false,
"id": "X4GPYVyI",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -241.7339986021227,
"y": -677.6404129245454,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 25,
"seed": 1722040825,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396352355,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "wZReN7-9szlRYBuKEJmoC",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 127,
"versionNonce": 343766713,
"isDeleted": false,
"id": "ZBe0o3D7",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -728.7086609752619,
"y": -704.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 278,
"height": 25,
"seed": 228336727,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "mysql> select * from orders;",
"rawText": "mysql> select * from orders;",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;"
},
{
"type": "text",
"version": 127,
"versionNonce": 1430272953,
"isDeleted": false,
"id": "fH4SeFGn",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -730.033546780883,
"y": -670.2531857554004,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 1156067481,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396289508,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 126,
"versionNonce": 787494809,
"isDeleted": false,
"id": "ZNWoA9Q4",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.1915945436672,
"y": -634.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 131,
"height": 25,
"seed": 23298423,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| id | price |",
"rawText": "| id | price |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| id | price |"
},
{
"type": "text",
"version": 126,
"versionNonce": 553871991,
"isDeleted": false,
"id": "hg6gXFjs",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.1915945436672,
"y": -599.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 1504228729,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 126,
"versionNonce": 1930943609,
"isDeleted": false,
"id": "nBKxfUMA",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.1915945436672,
"y": -564.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 136,
"height": 25,
"seed": 2055355031,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| 1 | 10 |",
"rawText": "| 1 | 10 |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| 1 | 10 |"
},
{
"type": "text",
"version": 132,
"versionNonce": 1251353335,
"isDeleted": false,
"id": "22FJUYZ1",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.4072151047468,
"y": -529.7505335004289,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 152,
"height": 25,
"seed": 298163801,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396887243,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| 3 | 30 |",
"rawText": "| 3 | 30 |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| 3 | 30 |"
},
{
"type": "text",
"version": 126,
"versionNonce": 548922713,
"isDeleted": false,
"id": "wZE9T6VK",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.1915945436672,
"y": -494.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 229429175,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 126,
"versionNonce": 1395030199,
"isDeleted": false,
"id": "6KY3c3Oq",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -729.1915945436672,
"y": -459.9725350096618,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 248,
"height": 25,
"seed": 202533689,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396221721,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "2 rows in set (0.00 sec)",
"rawText": "2 rows in set (0.00 sec)",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "2 rows in set (0.00 sec)"
},
{
"type": "text",
"version": 425,
"versionNonce": 1280240279,
"isDeleted": false,
"id": "CAo486kJ",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -868.7897242350843,
"y": 27.355855756303356,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 595,
"height": 41,
"seed": 1479523545,
"groupIds": [],
"roundness": null,
"boundElements": null,
"updated": 1674397176124,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)",
"rawText": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)",
"baseline": 35,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders where 10 < price and price < 30 for update;\nEmpty set (0.00 sec)"
},
{
"type": "rectangle",
"version": 782,
"versionNonce": 1553546681,
"isDeleted": false,
"id": "anMzDrP1vQ_OSV8LEKGSW",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 78.26315905584772,
"y": -179.03006398801483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 84,
"seed": 78454841,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "PYFHvKEp"
}
],
"updated": 1674397183016,
"link": null,
"locked": false
},
{
"type": "text",
"version": 775,
"versionNonce": 2104705463,
"isDeleted": false,
"id": "PYFHvKEp",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 111.76315905584772,
"y": -162.03006398801483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 184,
"height": 50,
"seed": 1079958487,
"groupIds": [],
"roundness": null,
"boundElements": null,
"updated": 1674397186638,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "insert into orders \nvalues('4', 40);",
"rawText": "insert into orders values('4', 40);",
"baseline": 43,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "anMzDrP1vQ_OSV8LEKGSW",
"originalText": "insert into orders values('4', 40);"
},
{
"type": "text",
"version": 117,
"versionNonce": 771432089,
"isDeleted": false,
"id": "WtPGnNol",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 381.9722894910295,
"y": -169.32740740286943,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 357,
"height": 25,
"seed": 510570777,
"groupIds": [],
"roundness": null,
"boundElements": null,
"updated": 1674397183016,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "Query OK, 1 row affected (0.01 sec)",
"rawText": "Query OK, 1 row affected (0.01 sec)",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "Query OK, 1 row affected (0.01 sec)"
},
{
"id": "l0eH9j1q",
"type": "text",
"x": -976.7030987024133,
"y": 390.84363762775195,
"width": 721,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 1701696695,
"version": 80,
"versionNonce": 1613960279,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "mysql> select * from orders where 10 < price and price < 30 for update;",
"rawText": "mysql> select * from orders where 10 < price and price < 30 for update;",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "mysql> select * from orders where 10 < price and price < 30 for update;"
},
{
"id": "zZF77DOD",
"type": "text",
"x": -976.7030987024133,
"y": 425.84363762775195,
"width": 145,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 1351628345,
"version": 80,
"versionNonce": 1064845465,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "+------+-------+",
"rawText": "+------+-------+",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "+------+-------+"
},
{
"id": "EnIG3geb",
"type": "text",
"x": -976.7030987024133,
"y": 460.84363762775195,
"width": 131,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 1751131607,
"version": 80,
"versionNonce": 1134326135,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "| id | price |",
"rawText": "| id | price |",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "| id | price |"
},
{
"id": "VTZ27i6A",
"type": "text",
"x": -976.7030987024133,
"y": 495.84363762775195,
"width": 145,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 1769932569,
"version": 80,
"versionNonce": 666289529,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "+------+-------+",
"rawText": "+------+-------+",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "+------+-------+"
},
{
"id": "iFwg8Qmv",
"type": "text",
"x": -976.7030987024133,
"y": 530.843637627752,
"width": 153,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 925586167,
"version": 80,
"versionNonce": 1746741911,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "| 2 | 20 |",
"rawText": "| 2 | 20 |",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "| 2 | 20 |"
},
{
"id": "WDffaa2t",
"type": "text",
"x": -976.7030987024133,
"y": 565.843637627752,
"width": 145,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 572570617,
"version": 80,
"versionNonce": 328314457,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "+------+-------+",
"rawText": "+------+-------+",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "+------+-------+"
},
{
"id": "9RnqcOHx",
"type": "text",
"x": -976.7030987024133,
"y": 600.843637627752,
"width": 229,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 441703447,
"version": 80,
"versionNonce": 1785315255,
"isDeleted": false,
"boundElements": null,
"updated": 1674397261725,
"link": null,
"locked": false,
"text": "1 row in set (0.00 sec)",
"rawText": "1 row in set (0.00 sec)",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": "1 row in set (0.00 sec)"
},
{
"type": "text",
"version": 153,
"versionNonce": 370354231,
"isDeleted": true,
"id": "Z3De3iAL",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 375.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 438,
"height": 25,
"seed": 172141239,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "mysql> select * from orders where price<=10;",
"rawText": "mysql> select * from orders where price<=10;",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders where price<=10;"
},
{
"type": "text",
"version": 153,
"versionNonce": 1715198649,
"isDeleted": true,
"id": "Gz61qQ7K",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 410.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 815513657,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 153,
"versionNonce": 269420887,
"isDeleted": true,
"id": "ddnFD0bY",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 445.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 131,
"height": 25,
"seed": 136985559,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| id | price |",
"rawText": "| id | price |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| id | price |"
},
{
"type": "text",
"version": 153,
"versionNonce": 54664089,
"isDeleted": true,
"id": "06RTdNRQ",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 480.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 327766297,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 154,
"versionNonce": 1580320375,
"isDeleted": true,
"id": "nbmZPt6I",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 515.9912402041978,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 149,
"height": 25,
"seed": 1094887671,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| 0 | 0 |",
"rawText": "| 0 | 0 |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| 0 | 0 |"
},
{
"type": "text",
"version": 153,
"versionNonce": 730677369,
"isDeleted": true,
"id": "ONfx9LQP",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 550.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 136,
"height": 25,
"seed": 1750189561,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| 1 | 10 |",
"rawText": "| 1 | 10 |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| 1 | 10 |"
},
{
"type": "text",
"version": 153,
"versionNonce": 255844247,
"isDeleted": true,
"id": "Xyka5uMO",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 585.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 1393586711,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 153,
"versionNonce": 1826670937,
"isDeleted": true,
"id": "Yr0lPosp",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -723.0248153348958,
"y": 620.76030536755,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 248,
"height": 25,
"seed": 2046336729,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674397258823,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "2 rows in set (0.00 sec)",
"rawText": "2 rows in set (0.00 sec)",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "2 rows in set (0.00 sec)"
},
{
"id": "NJwiKZnT",
"type": "text",
"x": -50.82363758735664,
"y": 392.37528713059294,
"width": 11,
"height": 25,
"angle": 0,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"groupIds": [],
"roundness": null,
"seed": 535249433,
"version": 4,
"versionNonce": 1147270711,
"isDeleted": true,
"boundElements": null,
"updated": 1674397221246,
"link": null,
"locked": false,
"text": "",
"rawText": "",
"fontSize": 20,
"fontFamily": 1,
"textAlign": "left",
"verticalAlign": "top",
"baseline": 18,
"containerId": null,
"originalText": ""
}
],
"appState": {
"theme": "dark",
"viewBackgroundColor": "<span class="tag">#ffffff</span>",
"currentItemStrokeColor": "<span class="tag">#000000</span>",
"currentItemBackgroundColor": "transparent",
"currentItemFillStyle": "hachure",
"currentItemStrokeWidth": 1,
"currentItemStrokeStyle": "solid",
"currentItemRoughness": 1,
"currentItemOpacity": 100,
"currentItemFontFamily": 1,
"currentItemFontSize": 20,
"currentItemTextAlign": "left",
"currentItemStartArrowhead": null,
"currentItemEndArrowhead": "arrow",
"scrollX": 1308.59973843963,
"scrollY": 596.346303778498,
"zoom": {
"value": 0.55
},
"currentItemRoundness": "round",
"gridSize": null,
"colorPalette": {}
},
"files": {}
}
%%