[PYTHON/PYSQLITE] 파이썬 데이터 타입을 사용해 테이블 생성하기

■ 파이썬 데이터 타입을 사용해 테이블을 생성하는 방법을 보여준다.

▶ 예제 코드 (PY)


import sqlite3

connection = sqlite3.connect(":memory:")

cursor = connection.cursor()

cursor.execute("CREATE TABLE TABLE1 (NAME TEXT, AGE INTEGER, MONEY REAL);")
cursor.execute("CREATE TABLE TABLE2 (NAME str, AGE int, MONEY float);")

cursor.execute("INSERT INTO TABLE1 VALUES ('Tiger', 25, 123.45);")
cursor.execute("INSERT INTO TABLE2 VALUES ('Tiger', 25, 123.45);")

cursor.execute("SELECT * FROM TABLE1")

for rowTuple in cursor:
    print(rowTuple)

print()

cursor.execute("SELECT * FROM TABLE2")

for rowTuple in cursor:
    print(rowTuple)

"""
('Tiger', 25, 123.45)

('Tiger', 25, 123.45)
"""

import sqlite3

connection = sqlite3.connect(":memory:")

cursor = connection.cursor()

cursor.execute("CREATE TABLE TABLE1 (NAME TEXT, AGE INTEGER, MONEY REAL);")

cursor.execute("CREATE TABLE TABLE2 (NAME str, AGE int, MONEY float);")

cursor.execute("INSERT INTO TABLE1 VALUES ('Tiger', 25, 123.45);")

cursor.execute("INSERT INTO TABLE2 VALUES ('Tiger', 25, 123.45);")

cursor.execute("SELECT * FROM TABLE1")

for rowTuple in cursor:

print(rowTuple)

print()

cursor.execute("SELECT * FROM TABLE2")

for rowTuple in cursor:

print(rowTuple)

"""

('Tiger', 25, 123.45)

"""