Mysql数据库更改后怎么保存

-- 插入一条记录
INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

-- 更新一条记录
UPDATE users SET email = 'john_new@example.com' WHERE name = 'John Doe';

-- 删除一条记录
DELETE FROM users WHERE name = 'John Doe';

-- 开始一个事务
START TRANSACTION;

try {
    -- 插入一条记录
    INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

    -- 更新一条记录
    UPDATE users SET email = 'john_new@example.com' WHERE name = 'John Doe';

    -- 提交事务
    COMMIT;
} catch (Exception e) {
    -- 发生错误时回滚事务
    ROLLBACK;
}

import mysql.connector

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

cursor = db.cursor()

try:
    # 开始事务
    cursor.execute("START TRANSACTION")

    # 执行更改操作
    cursor.execute("INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')")
    cursor.execute("UPDATE users SET email = 'john_new@example.com' WHERE name = 'John Doe'")

    # 提交事务
    db.commit()
    print("更改已成功保存")

except mysql.connector.Error as err:
    # 发生错误时回滚事务
    db.rollback()
    print(f"发生错误：{err}")

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