python - 有没有办法使用 SQL 数据结构在 python 中打印列？

Question

我收到了一项任务，要使用 SQL 编写有关我的 friend 的表格。这是代码。

import sqlite3 as lite
import sys

con = lite.connect('test.db')

with con:
    cur = con.cursor()


cur.execute("DROP TABLE IF EXISTS Freinds")
cur.execute("CREATE TABLE Friends(FirstName TEXT, LastName TEXT, Age INT, Gender TEXT)")
cur.execute("INSERT INTO Friends VALUES('Tom', 'Collins', 14, 'Male')")
cur.execute("INSERT INTO Friends VALUES('Zak', 'Baker', 14, 'Male')")
cur.execute("INSERT INTO Friends VALUES('Matt', 'Breeze', 14, 'Male')")
cur.execute("INSERT INTO Friends VALUES('Lara', 'Nevins', 14, 'Female')")
cur.execute("INSERT INTO Friends VALUES('David', 'Fawole', 14, 'Not Sure')")
cur.execute("INSERT INTO Friends VALUES('Emma', 'Williams', 14, 'Female')")
cur.execute("INSERT INTO Friends VALUES('Bailey', 'West', 14, 'Male')")

rows = cur.fetchall()

for row in rows:
    print(row)

cur2 = con .cursor()
cur2.execute("SELECT * FROM Friends LIMIT 5")

rs = cur2.fetchall()
print("print top five records only")

for row in rs:
    print(row)

# cur2.execute("SELECT * FROM Friends ")

在代码的最后一行中，我想打印“性别”列，但仅打印“男性”的姓名。

Answer 1

您真的要打印“性别”专栏吗？或者可能是名字？如果是这样，请看这里:

for row in cur.execute("SELECT FirstName FROM Friends WHERE Gender='Male''"):
    print(row)