SQLite (2) 썸네일형 리스트형 [Python] sqlite3 모듈 사용 예제 import sqlite3 def create_lotto645_db(): conn = sqlite3.connect('lotto645.db') c = conn.cursor() c.execute('''CREATE TABLE T_LOTTO645NUM (NUM INT, CONSTRAINT T_LOTTO645NUM_NUM_PK PRIMARY KEY(NUM))''') c.execute('''CREATE TABLE T_LOTTO645 (ROUND INT, NO1 INT, NO2 INT, NO3 INT, NO4 INT, NO5 INT, NO6 INT, NO7 INT, CONSTRAINT T_LOTTO645_ROUND_PK PRIMARY KEY(ROUND))''') c.execute('''CREATE VIEW V_LOT.. [Ubuntu] DB Browser for SQLite Installation # sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser # sudo apt-get update # sudo apt-get install sqlitebrowser Downloads - DB Browser for SQLite (sqlitebrowser.org) Downloads - DB Browser for SQLite (Please consider sponsoring us on Patreon 😄) Windows Our latest release (3.12.2) for Windows: Free code signing provided by SignPath.io, certificate by SignPath Foundation. Windows PortableApp N.. 이전 1 다음