Question

怎么让pymysql切换python3版本

Answer 1

connDB(data):
10 conn = pymysql.connect(host='localhost',user='root',passwd='#######',db='test',) #数据库
11 cur = conn.cursor() #游标
12 cur.execute('create database if not exists test;') #执语句行
13 cur.execute('create table if not exists test1(id INT NOT NULL, num VARCHAR(40) );')
14 for i in range(len(data)):
15 cur.execute('insert into test1 (id,num) values("{0}","{1}");'.format(i,data[i])) #{0} {1} 要和sql语句区分
16 cur.close() #关游标
17 conn.commit()
18 conn.close() #关数据库