# 连接数据库
import pymysql
db=pymysql.connect(
    host='localhost',
    port=3306,
    database='test',
    user='root',
    password='',
    charset='utf8'
)
# # 创建游标
cursor = db.cursor()
for i in range(0, 10):
        sql = "insert into person values(%s,%s,%s,%s)"
        print("第", i + 1, "次输入")
        param = [input("请输入姓名："), input("请输入年龄："), input("请输入性别："), input("请输入身高：")]
        cursor.execute(sql, param)
        db.commit()
# 关闭
cursor.close()
db.close()