Mysql快照读下解决幻读
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠==
Text Elements
事务A ^b7TiLH2p
事务B ^bMLs1cuE
select * from orders; ^nEabCTcv
insert into orders values('3', 30); ^L5cXt96O
begin; ^qY0JCakz
begin; ^4g4ylnvR
mysql> select * from orders;
+------+-------+
| id | price |
+------+-------+
| 1 | 10 |
| 2 | 20 |
+------+-------+ ^NByx8zNb
select * from orders; ^XYI6950h
mysql> select * from orders;
+------+-------+
| id | price |
+------+-------+
| 1 | 10 |
| 2 | 20 |
+------+-------+ ^32eQgah5
commit; ^VRiojIBx
commit; ^jIo8kxVG
select * from orders; ^K22PWYHL
mysql> select * from orders;
+------+-------+
| id | price |
+------+-------+
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
+------+-------+ ^gWpduRds
select * from orders; ^6UgsZYrO
mysql> select * from orders; ^9fGt5cPX
+------+-------+ ^YKfzteNa
| id | price | ^azGetZ1k
+------+-------+ ^PjFeYcM7
| 1 | 10 | ^kvmKTk7O
| 2 | 20 | ^iQqKOx4a
+------+-------+ ^94uNiNCP
2 rows in set (0.00 sec) ^bhwLGIko
%%
Drawing
{
"type": "excalidraw",
"version": 2,
"source": "https://excalidraw.com",
"elements": [
{
"type": "rectangle",
"version": 116,
"versionNonce": 2036428116,
"isDeleted": false,
"id": "Cq4Fb8jKBNu6oLIQ51jqq",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -265.41987136222053,
"y": -551.51806483214,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1214314743,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "b7TiLH2p"
}
],
"updated": 1674481448882,
"link": null,
"locked": false
},
{
"type": "text",
"version": 64,
"versionNonce": 1505083884,
"isDeleted": false,
"id": "b7TiLH2p",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -166.91987136222053,
"y": -518.51806483214,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 54,
"height": 31,
"seed": 620787193,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务A",
"rawText": "事务A",
"baseline": 22,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "Cq4Fb8jKBNu6oLIQ51jqq",
"originalText": "事务A"
},
{
"type": "rectangle",
"version": 205,
"versionNonce": 384869076,
"isDeleted": false,
"id": "YiMrXy7Kkz9DsUMHNcJmx",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 67.54641642915601,
"y": -553.1638544250144,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 31769111,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "bMLs1cuE"
}
],
"updated": 1674481448883,
"link": null,
"locked": false
},
{
"type": "text",
"version": 155,
"versionNonce": 134128748,
"isDeleted": false,
"id": "bMLs1cuE",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 165.046416429156,
"y": -520.1638544250144,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 56,
"height": 31,
"seed": 223432409,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务B",
"rawText": "事务B",
"baseline": 22,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "YiMrXy7Kkz9DsUMHNcJmx",
"originalText": "事务B"
},
{
"type": "rectangle",
"version": 188,
"versionNonce": 2013079636,
"isDeleted": false,
"id": "sWTz023mYp9JWW67y7APE",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -264.4676078322816,
"y": -345.7453378338897,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 642934583,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "nEabCTcv"
}
],
"updated": 1674481448883,
"link": null,
"locked": false
},
{
"type": "text",
"version": 148,
"versionNonce": 1879521004,
"isDeleted": false,
"id": "nEabCTcv",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -243.4676078322816,
"y": -312.7453378338897,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 27,
"seed": 1809058745,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "sWTz023mYp9JWW67y7APE",
"originalText": "select * from orders;"
},
{
"type": "rectangle",
"version": 477,
"versionNonce": 1616707028,
"isDeleted": false,
"id": "2g7wGg5LwigopS6a76LE0",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 65.74329682200926,
"y": -238.30436982600443,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1947101271,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "L5cXt96O"
}
],
"updated": 1674481448883,
"link": null,
"locked": false
},
{
"type": "text",
"version": 571,
"versionNonce": 509180268,
"isDeleted": false,
"id": "L5cXt96O",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 99.24329682200926,
"y": -217.80436982600443,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 184,
"height": 54,
"seed": 1756114073,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "insert into orders \nvalues('3', 30);",
"rawText": "insert into orders values('3', 30);",
"baseline": 45,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "2g7wGg5LwigopS6a76LE0",
"originalText": "insert into orders values('3', 30);"
},
{
"type": "rectangle",
"version": 238,
"versionNonce": 690365268,
"isDeleted": false,
"id": "wlrEc0dZZstw3uTup22_O",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -266.25186240684786,
"y": -448.4965741422153,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1760380279,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "qY0JCakz"
}
],
"updated": 1674481448883,
"link": null,
"locked": false
},
{
"type": "text",
"version": 204,
"versionNonce": 2118085612,
"isDeleted": false,
"id": "qY0JCakz",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -166.25186240684786,
"y": -415.4965741422153,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 27,
"seed": 1535979897,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "wlrEc0dZZstw3uTup22_O",
"originalText": "begin;"
},
{
"type": "rectangle",
"version": 321,
"versionNonce": 414095572,
"isDeleted": false,
"id": "2k8AvcBMJhrTBUqiPs-zm",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 66.49653312523094,
"y": -447.3890993828726,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1412660887,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "4g4ylnvR"
}
],
"updated": 1674481448883,
"link": null,
"locked": false
},
{
"type": "text",
"version": 287,
"versionNonce": 29560428,
"isDeleted": false,
"id": "4g4ylnvR",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 166.49653312523094,
"y": -414.3890993828726,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 27,
"seed": 1505401433,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448883,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "2k8AvcBMJhrTBUqiPs-zm",
"originalText": "begin;"
},
{
"type": "text",
"version": 103,
"versionNonce": 982277716,
"isDeleted": false,
"id": "NByx8zNb",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -594.2631371979143,
"y": -350.79558231496196,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 236,
"height": 168,
"seed": 680891319,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+",
"rawText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+",
"baseline": 160,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+"
},
{
"type": "rectangle",
"version": 456,
"versionNonce": 1236164844,
"isDeleted": false,
"id": "f_1KGPOQ1hPEcdnDcaxRY",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -266.686155694945,
"y": -33.381539869673276,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 67626809,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "XYI6950h"
}
],
"updated": 1674481448884,
"link": null,
"locked": false
},
{
"type": "text",
"version": 414,
"versionNonce": 932541396,
"isDeleted": false,
"id": "XYI6950h",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -245.686155694945,
"y": -0.3815398696732757,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 27,
"seed": 238552279,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "f_1KGPOQ1hPEcdnDcaxRY",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 373,
"versionNonce": 1300980588,
"isDeleted": false,
"id": "32eQgah5",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -595.2442575284862,
"y": -26.7508095487552,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 236,
"height": 168,
"seed": 349739033,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+",
"rawText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+",
"baseline": 160,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n+------+-------+"
},
{
"type": "rectangle",
"version": 516,
"versionNonce": 769644884,
"isDeleted": false,
"id": "PCeyumWbK3KYR196QPm0Q",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -268.55173482981616,
"y": 80.95588023393768,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 883905015,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "VRiojIBx"
}
],
"updated": 1674481448884,
"link": null,
"locked": false
},
{
"type": "text",
"version": 493,
"versionNonce": 61085164,
"isDeleted": false,
"id": "VRiojIBx",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -177.05173482981616,
"y": 113.95588023393768,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 27,
"seed": 773860601,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "PCeyumWbK3KYR196QPm0Q",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 553,
"versionNonce": 146902740,
"isDeleted": false,
"id": "Q8UAqgpd_xkQ_0OV5At9G",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 67.51251875725552,
"y": -132.0719541709889,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1694497559,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "jIo8kxVG"
}
],
"updated": 1674481448884,
"link": null,
"locked": false
},
{
"type": "text",
"version": 529,
"versionNonce": 151156844,
"isDeleted": false,
"id": "jIo8kxVG",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 159.01251875725552,
"y": -99.0719541709889,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 27,
"seed": 1734485465,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "Q8UAqgpd_xkQ_0OV5At9G",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 595,
"versionNonce": 1490064468,
"isDeleted": false,
"id": "EMdIiEx0fP_uXeiX3j-dh",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -267.546095446345,
"y": 204.49783275713287,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1402896439,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "K22PWYHL"
}
],
"updated": 1674481448884,
"link": null,
"locked": false
},
{
"type": "text",
"version": 553,
"versionNonce": 1232112364,
"isDeleted": false,
"id": "K22PWYHL",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -246.54609544634502,
"y": 237.49783275713287,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 27,
"seed": 464650937,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "EMdIiEx0fP_uXeiX3j-dh",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 397,
"versionNonce": 736291284,
"isDeleted": false,
"id": "gWpduRds",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -580.5034179693386,
"y": 196.21573430782686,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 236,
"height": 192,
"seed": 846160215,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n| 3 | 30 |\n+------+-------+",
"rawText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n| 3 | 30 |\n+------+-------+",
"baseline": 184,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 10 |\n| 2 | 20 |\n| 3 | 30 |\n+------+-------+"
},
{
"type": "rectangle",
"version": 377,
"versionNonce": 662195564,
"isDeleted": false,
"id": "dnrEAC-v8ruqKBWq84weC",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -266.23303841061966,
"y": -670.7455295336138,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 529169593,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "6UgsZYrO"
}
],
"updated": 1674481448884,
"link": null,
"locked": false
},
{
"type": "text",
"version": 393,
"versionNonce": 1695453012,
"isDeleted": false,
"id": "6UgsZYrO",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -245.23303841061966,
"y": -637.7455295336138,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 27,
"seed": 1374914391,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "dnrEAC-v8ruqKBWq84weC",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 283,
"versionNonce": 610516972,
"isDeleted": false,
"id": "9fGt5cPX",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -591.6769565036252,
"y": -671.6139718963528,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 278,
"height": 27,
"seed": 510426521,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448884,
"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": 283,
"versionNonce": 346653908,
"isDeleted": false,
"id": "YKfzteNa",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -593.0018423092461,
"y": -636.8946226420916,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 27,
"seed": 718701687,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 282,
"versionNonce": 138207852,
"isDeleted": false,
"id": "azGetZ1k",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -592.1598900720305,
"y": -601.6139718963528,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 131,
"height": 27,
"seed": 1998283385,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"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": 283,
"versionNonce": 1347013204,
"isDeleted": false,
"id": "PjFeYcM7",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -591.9785284648876,
"y": -566.43261028921,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 27,
"seed": 614260119,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 282,
"versionNonce": 164476140,
"isDeleted": false,
"id": "kvmKTk7O",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -592.1598900720305,
"y": -531.6139718963528,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 136,
"height": 27,
"seed": 643476313,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"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": 282,
"versionNonce": 180707284,
"isDeleted": false,
"id": "iQqKOx4a",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -592.1598900720305,
"y": -496.61397189635284,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 153,
"height": 27,
"seed": 41620151,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "| 2 | 20 |",
"rawText": "| 2 | 20 |",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "| 2 | 20 |"
},
{
"type": "text",
"version": 282,
"versionNonce": 1990211436,
"isDeleted": false,
"id": "94uNiNCP",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -592.1598900720305,
"y": -461.61397189635284,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 27,
"seed": 1149098041,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 282,
"versionNonce": 1815233876,
"isDeleted": false,
"id": "bhwLGIko",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -592.1598900720305,
"y": -426.61397189635284,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 248,
"height": 27,
"seed": 756392919,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674481448885,
"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)"
}
],
"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": 623.3489205496651,
"scrollY": 977.929587544263,
"zoom": {
"value": 0.4
},
"currentItemRoundness": "round",
"gridSize": null,
"colorPalette": {}
},
"files": {}
}
%%