使用python在sql中上传数据时出错

import pymysql

try:
    conn = pymysql.connect(host='localhost', user='user', password='password', db='database')
except pymysql.Error as e:
    print(f"Error connecting to database: {e}")

data = {'name': 'John', 'age': 30}
cursor.execute("INSERT INTO users (name, age) VALUES (%s, %s)", (data['name'], data['age']))

cursor.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ('John', 30))

GRANT INSERT ON database.users TO 'user'@'localhost';

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='user', password='password', db='database')
cursor = conn.cursor()

# 数据
data = {'name': 'John', 'age': 30}

try:
    # 执行SQL语句
    cursor.execute("INSERT INTO users (name, age) VALUES (%s, %s)", (data['name'], data['age']))
    # 提交事务
    conn.commit()
except pymysql.Error as e:
    print(f"Error: {e}")
    conn.rollback()
finally:
    cursor.close()
    conn.close()