pythonから sqlite3を使うサンプル (カラム名使う編)

gistfile1.py

#!/usr/bin/env python                                                                                                     
# -*- coding: utf-8 -*-                                                                                                   
 
import sqlite3
 
if __name__ == "__main__":
    con = sqlite3.connect("dbname.db")
    con.row_factory = sqlite3.Row
    for row in con.execute("select col1, col2 from table_name"):
        print row['col1'], row['col2']
    con.close()