练习1:python 导入csv文件到数据库

# -*- coding: utf-8 -*-
"""
Created on Fri Nov 23 14:29:11 2018

@author: Administrator
"""

import csv
import pymysql

filename="1.csv"

data=0

with open(filename,'r',encoding="gbk") as f:
    reader=csv.reader(f)
    data=list(reader)
    print(data[2])
    
db=pymysql.connect('localhost','root','121212','stock_tbl')
cursor=db.cursor()

sql="INSERT INTO stock_tbl(data_a,code_a,name_a,close_a,max_a,mini_a,start_a,yclose_a,zhangdie_a,zhangfu_a,cjl_a,cjj_a) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
cursor.executemany(sql,data)

print("数据库导入操作")

db.commit()
db.close