DBのデータを全部カラムごと表示
import sqlite3
def main():
conn = sqlite3.connect("TEST.db")
cur = conn.cursor()
for row in cur.execute('SELECT * FROM persons'):
print(row[0])
print(row[1])
conn.close()
if name == "main":
main()
PythonDBのデータを全部カラムごと表示
import sqlite3
def main():
conn = sqlite3.connect("TEST.db")
cur = conn.cursor()
for row in cur.execute('SELECT * FROM persons'):
print(row[0])
print(row[1])
conn.close()
if name == "main":
main()
Comments