基于外键名称更新一行中的多个值

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

CREATE TABLE orders (
    id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    total_amount DECIMAL(10, 2),
    FOREIGN KEY (customer_id) REFERENCES customers(id)
);

UPDATE orders
SET total_amount = total_amount * 1.1
WHERE customer_id = (SELECT id FROM customers WHERE name = 'John Doe');

BEGIN TRANSACTION;

UPDATE orders
SET total_amount = total_amount * 1.1
WHERE customer_id = (SELECT id FROM customers WHERE name = 'John Doe');

-- 检查是否有错误
IF @@ERROR <> 0
BEGIN
    ROLLBACK TRANSACTION;
    PRINT '更新失败';
END
ELSE
BEGIN
    COMMIT TRANSACTION;
    PRINT '更新成功';
END