MacOS 环境下 Python 访问 MySQL

pip3 install PyMySQL

python3

import pymysql
db = pymysql.connect('localhost', 'root', '******', 'mydbname')

cur = db.cursor()

cur.execute( 'select version()')

data = cur.fetchone()

data



f = open('/Volumes/....../test.csv')

for line in f.readlines():
  lst = line.split(',')
  cursor.execute('insert into test_tab (a, b, c, d) values(%s, %s, %s, %s)', lst[0:4])
  
  
db.commit()