pymysql链接数据库

import pymysql
#连接配置信息
config = {
          'host':'127.0.0.1',
          'port':3306,
          'user':'root',
          'password':'root',
          'db':'dbname',
          'charset':'utf8',
          'cursorclass':pymysql.cursors.DictCursor,
          }
# 创建连接
connection = pymysql.connect(**config)

#执行sql
try:
    with connection.cursor() as cursor:
        #执行sql语句，插入记录
        sql = 'INSERT INTO tablename (fName,bName,sName,productIdVal,real_price,img_url,real_info) VALUES(%s,%s,%s,%s,%s,%s,%s)'
        cursor.execute(sql,('包袋','普拉达','双肩包','24880440','15365','http://www.xxxxxx.com/product/8eea71366fb1f53cd65.jpg','产地：意大利,颜色：黑色,材质：牛皮'))
        connection.commit()
finally:
    connection.close()