[파이썬]주피터박스로 SQL DB사용

import sqlite3
conn=sqlite3.connect('test.db')
cursor = conn.cursor()
sql='''
    create table data(
        id integer primary key autoincrement,
        title varchar(100)
    )
'''
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()

튜플을 사용할 때 요소가 한개라도 ,(쉼표)를 붙여줘야함

conn=sqlite3.connect('test.db')
cursor = conn.cursor()
sql='''
    select id,title from data limit ?,10 #?부터 10까지 출력
'''
cursor.execute(sql)
result =cursor.fetchall()
for row in result:
    print(row[0],row[1])
conn.commit()
cursor.close()
conn.close()