• 关系数据库的使用

# import sqlite3stocks = [    ('GOOG', 100, 490.1),    ('AAPL', 50, 545.75),    ('FB', 150, 7.45),    ('HPQ', 75, 33.2),]db = sqlite3.connect('database.db')c = db.cursor()c.execute('create table portfolio (symbol text, shares integer, price real)')db.commit()c.executemany('insert into portfolio values (?,?,?)', stocks)db.commit()for row in db.execute('select * from portfolio'):    print(row)

('GOOG', 100, 490.1)('AAPL', 50, 545.75)('FB', 150, 7.45)('HPQ', 75, 33.2)