import sqlite3
connection= sqlite3.connect('sqlite.db')
cursor= connection.cursor()
table_query = '''CREATE TABLE if not Exists Student
(Name text, Course text, Age real)'''
cursor.execute(table_query)
students_data = [
['AlixaProDev','CS',19],
['Alixawebdev','BBa',21],
['AskALixa','Software',22]
]
insert_q = []
for std_data in students_data:
name = std_data[0]
course = std_data[1]
age = std_data[2]
q=f"INSERT INTO Student VALUES ('{name}','{course}','{age}')"
insert_q.append(q)
for q in insert_q:
cursor.execute(q)
connection.commit()
connection.close()