向表中插入数据

import pymysql
# 创建与数据库的连接
con = pymysql.connect(host = 'localhost',user = 'root',password = '123456',database = 'python_db',port = 3306)
# 创建游标对象
cur = con.cursor()
# 插入sql语句
sql = 'insert into python_data(id,name,age,score) values(%s,%s,%s,%s)'

try:
    # 执行sql
    # 在execute中第二个参数，插入列表，元素是元组，代表values
    # cur.execute()   插入一条数据
    cur.executemany(sql,[(1,'张三',23,99.2),(2,'好好',24,79.1),(3,'周周',23,89.8)])
    # 提交事务
    con.commit()
    print('插入数据成功')
except Exception as e:
    print(e)
    con.rollback()    #回滚
    print('插入数据失败')
finally:
    con.close()