aboutsummaryrefslogtreecommitdiff
path: root/05-advanced-sql-queries
diff options
context:
space:
mode:
authorW. Kosior <koszko@koszko.org>2026-10-20 14:47:45 +0200
committerW. Kosior <koszko@koszko.org>2026-10-20 14:47:45 +0200
commite663b0bc37ad8861662f41552cbeb47298b4cc78 (patch)
treee558f6389d7fb331d13ddc485e0529cd7909aa02 /05-advanced-sql-queries
parenteb811ba7383972a6d9b815e4bb1ca48e25715348 (diff)
downloadAGH-db-lectures-magister.tar.gz
AGH-db-lectures-magister.zip
Mention MariaDB `LIMIT'-first syntax in `05-advanced-sql-queries'.HEADmagister
Diffstat (limited to '05-advanced-sql-queries')
-rw-r--r--05-advanced-sql-queries/advanced-sql-queries.ipynb20
1 files changed, 20 insertions, 0 deletions
diff --git a/05-advanced-sql-queries/advanced-sql-queries.ipynb b/05-advanced-sql-queries/advanced-sql-queries.ipynb
index 9ec4ce4..ffc64fd 100644
--- a/05-advanced-sql-queries/advanced-sql-queries.ipynb
+++ b/05-advanced-sql-queries/advanced-sql-queries.ipynb
@@ -149,6 +149,26 @@
]
},
{
+ "cell_type": "code",
+ "execution_count": null,
+ "id": "015934f7",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "%sql mysql:///agh_it_northwind?unix_socket=/var/run/mysql/mysql.sock"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "9f32e00b",
+ "metadata": {},
+ "source": [
+ "_notes_\n",
+ "\n",
+ "Ordering of `LIMIT` and `OFFSET` clauses in MariaDB — no longer arbitrary.\n"
+ ]
+ },
+ {
"cell_type": "markdown",
"id": "f456b374",
"metadata": {},