diff options
Diffstat (limited to 'content/posts/2024-01-05-mayim-sqlite.md')
| -rw-r--r-- | content/posts/2024-01-05-mayim-sqlite.md | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/content/posts/2024-01-05-mayim-sqlite.md b/content/posts/2024-01-05-mayim-sqlite.md index 3ce666a..a151bfe 100644 --- a/content/posts/2024-01-05-mayim-sqlite.md +++ b/content/posts/2024-01-05-mayim-sqlite.md @@ -182,7 +182,10 @@ GROUP BY product.id; Running that would result in rows with duplicated categories like: ```python -Product(id=1, name='energy drink', prices=[Price(id=1, unit='bottle', price=12000), Price(id=2, unit='packets', price=70000)], categories=['drink', 'drink']), +Product(id=1, name='energy drink', + prices=[Price(id=1, unit='bottle', price=12000), + Price(id=2, unit='packets', price=70000)], + categories=['drink', 'drink']), ``` This is because I joined three tables at once, and the categories are repeated |