python - 在 Python 中显示 SQL JOINED 表

Question

我LIMIT 3在下面的代码中添加了显示 JOINED 表的 3 个结果。但是在 Python 中显示了多行。在 SQL 执行中，没问题。

请指教是什么原因？谢谢

lib = cur.execute('''SELECT Track.title, Artist.name, Album.title, Genre.name
  FROM Track JOIN Genre JOIN Album JOIN Artist
  ON Track.genre_id = Genre.ID AND Track.album_id = Album.id
  AND Album.artist_id = Artist.id
  ORDER BY Artist.name  LIMIT 3''')
for row in lib:
  print(row)

标签： pythonsqlsqlite

Answer 1

尝试将其更改为：

 cur.execute('''SELECT Track.title, Artist.name, Album.title, Genre.name
  FROM Track JOIN Genre JOIN Album JOIN Artist
  ON Track.genre_id = Genre.ID AND Track.album_id = Album.id
  AND Album.artist_id = Artist.id
  ORDER BY Artist.name  LIMIT 3''')
lib = cur.fetchall()