import sqlite3

name = 'kevin'
school = 'sanzhong'
id_num = 20220314


conn = sqlite3.connect('./test.db')

cursor = conn.cursor()

sql = 'create table students (name text, school text, id int)'
sql_data = ''' insert into students
              (name, school, id)
              values
              ('kevin', 'sanzhong', 20220314)'''
#cursor.execute(sql)

cursor.execute("insert into students (name, school, id) values ('kevin', 'sanzhong', 20220314)")
cursor.execute("insert into students (name, school, id) values ('kevin', 'sanzhong', 20220314)")
cursor.execute("insert into students (name, school, id) values ('kevin', 'sanzhong', 20220314)")


conn.commit()

cursor.close()