ការបញ្ចូល​ទិន្នន័យ​ចូល​ទៅ​ក្នុង​តារាង​ទិន្នន័យ SQLite ត្រូវ​ធ្វើ​ឡើង​តាម​លំនាំ​ដូច​ខាង​ក្រោម​នេះ៖

 

import sqlite3
 
conn = sqlite3.connect('mydb.db')
cursor = conn.cursor()
 
cursor.execute('''INSERT INTO EMPLOYEE(
   FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES 
   ('Veasna', 'KEO', 27, 'F', 9000)''')
 
cursor.execute('''INSERT INTO EMPLOYEE(
   FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES 
   ('Vinay', 'KUNG', 20, 'M', 6000)''')
 
cursor.execute('''INSERT INTO EMPLOYEE(
   FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES 
   ('Sarika', 'VONG', 25, 'M', 8300)''')
 
cursor.execute('''INSERT INTO EMPLOYEE(
   FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES 
   ('Samantha', 'PECH', 26, 'F', 10000)''')
 
cursor.execute('''INSERT INTO EMPLOYEE(
   FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES 
   ('Thirit', 'KANN', 24, 'F', 6000)''')
 
conn.commit()
print("Records inserted........")
 
conn.close()