CTAzNTKz

1name_list = []
2
3number_list = []
4
5date = now.date()
6strDate = date.strftime("%B %Y")
7
8tableName = strDate
9
10sqlTable = 'CREATE TABLE IF NOT EXISTS ' + tableName + '(name text, number integer, date text)'
11
12c.execute(sqlTable)
13
14conn.commit()
15
16for i in name_list:
17    c.execute('INSERT INTO January2018(names) VALUES (?)', [i])
18    conn.commit()
19	
20for i in number_list:
21    c.execute('UPDATE myTable SET number = ? WHERE name', [i])
22    conn.commit()