FilesExpand file tree

 master

/

start_using_sqlite_with_python.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

16 lines (11 loc) · 620 Bytes

 master

/

start_using_sqlite_with_python.py

Copy path

Top

File metadata and controls

• Code
• Blame

16 lines (11 loc) · 620 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

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')