gittutorial/python/start_using_sqlite_with_python.py at master · MParsa-ES/gittutorial · GitHub

18 lines (12 loc) · 637 Bytes

import sqlite3

conn = sqlite3.connect('database_name.db') # connect to the database or create it if it doesn't exist before

c = conn.cursor() # use this cursor object to run sql commands

#for first run be OK but more not OK. Then add this line for more runs

c.execute('''drop table if exists table_name''')

c.execute('''create table table_name (col_1_name int, col_2_name int)''') # create a table with two columns

c.execute('''insert into table_name values (1, 1)''') # insert two records to that table

c.execute('''insert into table_name values (2, 2)''')

conn.commit() # commit changes

conn.close()

print('done')

print("finish")

Expand file tree