MySQL过程将数据插入到使用auto_increment的表中，生成PK auto_increment并将其插入到桥接器中？

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

SELECT id, name, email FROM users;

import mysql.connector
import requests

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="youruser",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 查询数据
cursor.execute("SELECT id, name, email FROM users")
rows = cursor.fetchall()

# 将数据插入到桥接器中
for row in rows:
    id, name, email = row
    response = requests.post("https://bridge.example.com/api/insert", json={"id": id, "name": name, "email": email})
    if response.status_code == 200:
        print(f"Inserted {name} successfully")
    else:
        print(f"Failed to insert {name}")

# 关闭连接
cursor.close()
db.close()