pymysql模块向数据库写入数据

import pymysql
db = pymysql.connect(
    user="root",  
    password="admin@123",
    db="test", 
    host="127.0.0.1"
)
db.autocommit(True)
cur = db.cursor()
while True:
	name = input('姓名：')
	sex  = input('性别：')
	age  = input('年龄：')
	sql = 'insert into tb1 (name,age,sex) value (%s,%s,%s)' % (name, age, sex)
	cur.execute(sql)