Cursor.executemany()
-
[Python] SQLite3 Cursor.executemany() - iterator를 이용한 레코드 추가Python/SQLite 2018. 5. 18. 23:37
DOCS : https://docs.python.org/3/library/sqlite3.html?highlight=cur%20executemany#sqlite3.Cursor.executemany Cursor.execute를 이용한 레코드 입력 import sqlite3 conn = sqlite3.connect(':memory:') cur = conn.cursor() cur.execute('CREATE TABLE Score(nation, point)') cur.execute('INSERT INTO Score (nation, point) VALUES(?,?)',('kr',90)) cur.execute('INSERT INTO Score (nation, point) VALUES(?,?)',('jp',80)) c..