Khmer Web: បញ្ចូលទិន្នន័យ

ការបញ្ចូលទិន្នន័យចូលទៅក្នុងតារាងទិន្នន័យ 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()