omg21
V2EX  ›  问与答

sqlite 查询到的结果只用能列表 index 显示吗?

  •  
  •   omg21 · Jan 25, 2017 · 1925 views
    This topic created in 3570 days ago, the information mentioned may be changed or developed.

    cursor = conn.execute("SELECT * from COMPANY") for row in cursor: print "ID = ", row[0] print "NAME = ", row[1] print "ADDRESS = ", row[2]

    我想用 row['NAME']来表示 NAME 的值,而不想用 row[1]来表示,这样太不直观了,有什么办法吗?

    3 replies  •  2017-01-25 16:11:11 +08:00
    jarlyyn
    jarlyyn
    Jan 25, 2017
    1
    const FieldName=1?
    kindjeff
    kindjeff
    Jan 25, 2017 via iPhone
    2
    去 python 的 sqlite 库文档里查一下 row_factory 这个参数。
    omg21
    omg21
    OP
    Jan 25, 2017
    3
    @kindjeff 多谢,用这个就解决了
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   4529 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 22ms · UTC 03:52 · PVG 11:52 · LAX 19:52 · JFK 22:52
    ♥ Do have faith in what you're doing.