Postgresql不可重复读
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠==
Text Elements
事务A ^EJKvgE8s
事务B ^if98ykqE
select * from orders; ^Gp5obo7a
update orders set price = 11 where id = '1'; ^mI9Uh8Jx
begin; ^K8yW5Awc
begin; ^CxoG6mEh
mysql> select * from orders;
+------+-------+
| id | price |
+------+-------+
| 1 | 10 |
| 2 | 20 |
+------+-------+ ^Ovj1FqYI
select * from orders; ^0Hq0ZWsX
mysql> select * from orders;
+------+-------+
| id | price |
+------+-------+
| 1 | 11 |
| 2 | 20 |
+------+-------+ ^ET7R7qcU
commit; ^FwmViOHF
commit; ^SnNzaE0p
select * from orders; ^vSW9RiFc
mysql> select * from orders; ^OI4x9Yun
+------+-------+ ^RlK7yv2H
| id | price | ^aBH7avXu
+------+-------+ ^aLldHS1x
| 1 | 10 | ^nM0mfEd1
| 2 | 20 | ^Xf4uA8tj
+------+-------+ ^ZPWxS4J9
2 rows in set (0.00 sec) ^7OnOp5h1
%%
Drawing
{
"type": "excalidraw",
"version": 2,
"source": "https://excalidraw.com",
"elements": [
{
"type": "rectangle",
"version": 113,
"versionNonce": 201132409,
"isDeleted": false,
"id": "3gUKfXC8wp3BDbd7d1fOR",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -346.30860149484784,
"y": -187.15823364257812,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1298452279,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "EJKvgE8s"
}
],
"updated": 1674393176907,
"link": null,
"locked": false
},
{
"type": "text",
"version": 62,
"versionNonce": 145397177,
"isDeleted": false,
"id": "EJKvgE8s",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -247.80860149484784,
"y": -154.15823364257812,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 54,
"height": 25,
"seed": 1190076665,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463874678,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务A",
"rawText": "事务A",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "3gUKfXC8wp3BDbd7d1fOR",
"originalText": "事务A"
},
{
"type": "rectangle",
"version": 202,
"versionNonce": 836363193,
"isDeleted": false,
"id": "8qmQT0c0xGvft34emKoIf",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -13.342313703471348,
"y": -188.8040232354525,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 744861785,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "if98ykqE"
}
],
"updated": 1674393176449,
"link": null,
"locked": false
},
{
"type": "text",
"version": 152,
"versionNonce": 490569303,
"isDeleted": false,
"id": "if98ykqE",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 84.15768629652865,
"y": -155.8040232354525,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 56,
"height": 25,
"seed": 2051988919,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463874681,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "事务B",
"rawText": "事务B",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "8qmQT0c0xGvft34emKoIf",
"originalText": "事务B"
},
{
"type": "rectangle",
"version": 185,
"versionNonce": 1589750361,
"isDeleted": false,
"id": "uDDsPNdZ2itFfDdr8dAZ8",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -345.3563379649089,
"y": 18.614493355672153,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 510620249,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "Gp5obo7a"
}
],
"updated": 1674393723043,
"link": null,
"locked": false
},
{
"type": "text",
"version": 145,
"versionNonce": 658998199,
"isDeleted": false,
"id": "Gp5obo7a",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -324.3563379649089,
"y": 51.61449335567215,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 25,
"seed": 1480211383,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674393723043,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "uDDsPNdZ2itFfDdr8dAZ8",
"originalText": "select * from orders;"
},
{
"type": "rectangle",
"version": 474,
"versionNonce": 930900505,
"isDeleted": false,
"id": "VgjS8MhyQXjDjTwN_rFHR",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -15.145433310617989,
"y": 126.0554613635575,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1062408183,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "mI9Uh8Jx"
}
],
"updated": 1674394025571,
"link": null,
"locked": false
},
{
"type": "text",
"version": 569,
"versionNonce": 950653111,
"isDeleted": false,
"id": "mI9Uh8Jx",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -6.645433310617989,
"y": 146.5554613635575,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 234,
"height": 50,
"seed": 1595887353,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463605477,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": " update orders set \nprice = 11 where id = '1';",
"rawText": " update orders set price = 11 where id = '1';",
"baseline": 43,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "VgjS8MhyQXjDjTwN_rFHR",
"originalText": " update orders set price = 11 where id = '1';"
},
{
"type": "rectangle",
"version": 235,
"versionNonce": 606300345,
"isDeleted": false,
"id": "KItHriNq3KX1UlW8_EnQ6",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -347.14059253947516,
"y": -84.13674295265349,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1097988537,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "K8yW5Awc"
}
],
"updated": 1674393492204,
"link": null,
"locked": false
},
{
"type": "text",
"version": 201,
"versionNonce": 1794627703,
"isDeleted": false,
"id": "K8yW5Awc",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -247.14059253947516,
"y": -51.13674295265349,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 25,
"seed": 1108236887,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674393494074,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "KItHriNq3KX1UlW8_EnQ6",
"originalText": "begin;"
},
{
"type": "rectangle",
"version": 318,
"versionNonce": 974059575,
"isDeleted": false,
"id": "AapgP_PbCq-qwUZzaZxeK",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -14.392197007396419,
"y": -83.02926819331066,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1696350361,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "CxoG6mEh"
}
],
"updated": 1674393441258,
"link": null,
"locked": false
},
{
"type": "text",
"version": 283,
"versionNonce": 168499033,
"isDeleted": false,
"id": "CxoG6mEh",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 85.60780299260358,
"y": -50.029268193310656,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 51,
"height": 25,
"seed": 976777591,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674393497174,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "begin;",
"rawText": "begin;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "AapgP_PbCq-qwUZzaZxeK",
"originalText": "begin;"
},
{
"type": "text",
"version": 102,
"versionNonce": 1921502103,
"isDeleted": false,
"id": "Ovj1FqYI",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -675.1518673305414,
"y": 13.564248874599855,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 229,
"height": 144,
"seed": 921223929,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396386040,
"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": 138,
"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": 453,
"versionNonce": 1643989273,
"isDeleted": false,
"id": "Nwa08WipGInlO4jdeXG7J",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -347.5748858275723,
"y": 330.9782913198886,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1744810935,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "0Hq0ZWsX"
}
],
"updated": 1674394022112,
"link": null,
"locked": false
},
{
"type": "text",
"version": 411,
"versionNonce": 1042952439,
"isDeleted": false,
"id": "0Hq0ZWsX",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -326.5748858275723,
"y": 363.9782913198886,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 25,
"seed": 1607452473,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674394022112,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "Nwa08WipGInlO4jdeXG7J",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 372,
"versionNonce": 1441096793,
"isDeleted": false,
"id": "ET7R7qcU",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -676.144802323502,
"y": 337.48603580096295,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 229,
"height": 144,
"seed": 462944601,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463883045,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+",
"rawText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+",
"baseline": 138,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+"
},
{
"type": "rectangle",
"version": 513,
"versionNonce": 1506212375,
"isDeleted": false,
"id": "RR8DgpJYA-TZ78HEAb2rv",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -349.44046496244346,
"y": 445.3157114234996,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 968849303,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "FwmViOHF"
}
],
"updated": 1674394022112,
"link": null,
"locked": false
},
{
"type": "text",
"version": 490,
"versionNonce": 1171166937,
"isDeleted": false,
"id": "FwmViOHF",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -257.94046496244346,
"y": 478.3157114234996,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 25,
"seed": 1573302617,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674394022112,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "RR8DgpJYA-TZ78HEAb2rv",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 550,
"versionNonce": 581888567,
"isDeleted": false,
"id": "-NYnDq5mZ9eNgXlqzEd4N",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -13.376211375371781,
"y": 232.287877018573,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 257451255,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "SnNzaE0p"
}
],
"updated": 1674394024033,
"link": null,
"locked": false
},
{
"type": "text",
"version": 526,
"versionNonce": 1404385465,
"isDeleted": false,
"id": "SnNzaE0p",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": 78.12378862462822,
"y": 265.287877018573,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 68,
"height": 25,
"seed": 2089142777,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674394024033,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "commit;",
"rawText": "commit;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "-NYnDq5mZ9eNgXlqzEd4N",
"originalText": "commit;"
},
{
"type": "rectangle",
"version": 375,
"versionNonce": 102996471,
"isDeleted": false,
"id": "d5tesZWHvv0nZw8c8nwov",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -351.8127780647317,
"y": -295.6219349163175,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 381093719,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "vSW9RiFc"
}
],
"updated": 1674396302036,
"link": null,
"locked": false
},
{
"type": "text",
"version": 389,
"versionNonce": 170694775,
"isDeleted": false,
"id": "vSW9RiFc",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -330.8127780647317,
"y": -262.6219349163175,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 25,
"seed": 429981081,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396360802,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "d5tesZWHvv0nZw8c8nwov",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 326,
"versionNonce": 1477472663,
"isDeleted": false,
"id": "OI4x9Yun",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -677.8477457153772,
"y": -295.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 278,
"height": 25,
"seed": 187303031,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396361584,
"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": 326,
"versionNonce": 1441268793,
"isDeleted": false,
"id": "RlK7yv2H",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -679.3433671980818,
"y": -260.8666072629602,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 398451321,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396363050,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 324,
"versionNonce": 2085501721,
"isDeleted": false,
"id": "aBH7avXu",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -225.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 131,
"height": 25,
"seed": 780164503,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"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": 324,
"versionNonce": 1662607095,
"isDeleted": false,
"id": "aLldHS1x",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -190.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 1047472985,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 324,
"versionNonce": 2095673337,
"isDeleted": false,
"id": "nM0mfEd1",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -155.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 136,
"height": 25,
"seed": 65966775,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"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": 324,
"versionNonce": 882927639,
"isDeleted": false,
"id": "Xf4uA8tj",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -120.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 153,
"height": 25,
"seed": 1711429689,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"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": 324,
"versionNonce": 839583961,
"isDeleted": false,
"id": "ZPWxS4J9",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -85.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 145,
"height": 25,
"seed": 874062807,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "+------+-------+",
"rawText": "+------+-------+",
"baseline": 18,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "+------+-------+"
},
{
"type": "text",
"version": 324,
"versionNonce": 245976375,
"isDeleted": false,
"id": "7OnOp5h1",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -678.5014149608658,
"y": -50.41538360055483,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 248,
"height": 25,
"seed": 274524441,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674396326775,
"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": "rectangle",
"version": 593,
"versionNonce": 1750655513,
"isDeleted": true,
"id": "ioxGGgLomCgZe3Mx1XA13",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -347.9699411388682,
"y": 569.3225483867989,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 251,
"height": 91,
"seed": 1175777529,
"groupIds": [],
"roundness": {
"type": 3
},
"boundElements": [
{
"type": "text",
"id": "zpPJSiij"
}
],
"updated": 1674463884635,
"link": null,
"locked": false
},
{
"type": "text",
"version": 551,
"versionNonce": 263235575,
"isDeleted": true,
"id": "zpPJSiij",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -326.9699411388682,
"y": 602.3225483867989,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 209,
"height": 25,
"seed": 111769367,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463884635,
"link": null,
"locked": false,
"fontSize": 20,
"fontFamily": 1,
"text": "select * from orders;",
"rawText": "select * from orders;",
"baseline": 18,
"textAlign": "center",
"verticalAlign": "middle",
"containerId": "ioxGGgLomCgZe3Mx1XA13",
"originalText": "select * from orders;"
},
{
"type": "text",
"version": 388,
"versionNonce": 420872983,
"isDeleted": true,
"id": "X8IIVnub",
"fillStyle": "hachure",
"strokeWidth": 1,
"strokeStyle": "solid",
"roughness": 1,
"opacity": 100,
"angle": 0,
"x": -661.5202608949346,
"y": 560.3205606145763,
"strokeColor": "<span class="tag">#000000</span>",
"backgroundColor": "transparent",
"width": 229,
"height": 144,
"seed": 1207041113,
"groupIds": [],
"roundness": null,
"boundElements": [],
"updated": 1674463887792,
"link": null,
"locked": false,
"fontSize": 16.549952923564145,
"fontFamily": 1,
"text": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+",
"rawText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+",
"baseline": 138,
"textAlign": "left",
"verticalAlign": "top",
"containerId": null,
"originalText": "mysql> select * from orders;\n+------+-------+\n| id | price |\n+------+-------+\n| 1 | 11 |\n| 2 | 20 |\n+------+-------+"
}
],
"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": 991.2595071174435,
"scrollY": 336.5491246508708,
"zoom": {
"value": 0.6000000000000001
},
"currentItemRoundness": "round",
"gridSize": null,
"colorPalette": {}
},
"files": {}
}
%%