python连接mysql数据库

import  pymysql
name='li';age=18;mongey=18000000
def save(item):
    connect=pymysql.connect(
        host='localhost',
        db='scrapy',
        user='root',
        password='root'
    )
    cursor=connect.cursor()#创建游标
    sql ="insert  into  数据表名(字段1，字段2，字段3)VALUES (%s,%s,%s)"
    try:
        cursor.execute(sql,(name,age,mongey))
        connect.commit()#提交游标
        print('数据插入1成功')
    except:
        print("数据插入失败")