向mysql数据库中插入一条或多条数据

# 导入模块
import pymysql
# 与数据库简历库连接
connect = pymysql.connect(host='127.0.0.1', user='root', password='root', database='reptile_db')
# 创建游标对象
# print(connect)
mycursor = connect.cursor()
# 准备sql语句
sql='insert into t_student(sno,sname,sex,age) values(6,"富贵","男",18)'
# 执行sql语句
mycursor.execute(sql)
# 提交数据
connect.commit()
# 关闭数据库连接
connect.close()

插入多条数据

# 导入模块
import pymysql
# 与数据库简历库连接
connect = pymysql.connect(host='127.0.0.1', user='root', password='root', database='reptile_db')
# 创建游标对象
# print(connect)
mycursor = connect.cursor()

# 一次插入多条数据
lst=[
    (7,"小刚","男",18),
    (8,"小红","女",17),
    (9,"百万","男",18)
]
# 准备sql语句，使用%s为待插入的值占位
sql='insert into t_student(sno,sname,sex,age) values(%s,%s,%s,%s)'
mycursor.executemany(sql,lst)

# 提交数据
connect.commit()
# 关闭数据库连接
connect.close()