March 2022
Intermediate to advanced
522 pages
13h 52m
Chinese
Content preview from Python语言及其应用（第2版）
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
472
｜
附录
D
('The Spellman Files',)
('The Weirdstone of Brisingamen',)
('Thud!',)
如果只想打印
title
的值，不需要元组形式（圆括号和逗号），那么可以试试这个：
>>> for row in db.execute(sql):
... print(row[0])
...
Perdido Street Station
Small Gods
The Spellman Files
The Weirdstone of Brisingamen
Thud!
如果想忽略标题中起始的
The
，则需要额外添加一些
SQL
。
>>> sql = '''select title from book order by
... case when (title like "The %")
... then substr(title, 5)
... else title end'''
>>> for row in db.execute(sql):
... print(row[0])
...
Perdido Street Station
Small Gods
The Spellman Files
Thud!
The Weirdstone of Brisingamen
7.
打印数据表
books
中的所有列（按照出版日期）。
>>> for row in db.execute('select * from book order by year'):