python,sqlite批量插入数值问题

Question

第一次接触数据库，怎么把datalist列表数据加入到sql表格里吖，批量操作的方法。
datalist = ['zhangsan',5000,'jz',2,56,'mnopq'
'liwangba',8000,'qz',5,87,'hijkl'
'xiaoqiang',7000,'qz',12,580,'abcde']
sql2 = '''
insert into Parttime (
Wname,saraly,Wstyle,Nnumber,hits,request
)
values (%s)'''%(datalist)
conn = sqlite3.connect(saveDB)
cursor = conn.cursor()
cursor.execute(sql2)
conn.commit()
conn.close()

Answer 1

import sqlite3
con = sqlite3.connect('example.db')
cur = con.cursor()
lang_list = [
("Fortran", 1957),
("Python", 1991),
("Go", 2009),
]
cur.executemany("insert into lang values (?, ?)", lang_list)
con.close()