DataReader,按列检索数据

import sqlite3

conn = sqlite3.connect('example.db')

cursor = conn.cursor()

query = 'SELECT * FROM some_table WHERE some_column = some_value'

cursor.execute(query)

row = cursor.fetchone()
while row is not None:
    print(row[0])
    row = cursor.fetchone()

conn.close()

import sqlite3

conn = sqlite3.connect('example.db')

cursor = conn.cursor()

query = 'SELECT column1, column2 FROM some_table WHERE some_column = some_value'

cursor.execute(query)

row = cursor.fetchone()
while row is not None:
    print(row[0], row[1])
    row = cursor.fetchone()

conn.close()