更新表中的多个字段

UPDATE employees
SET age = CASE id
            WHEN 1 THEN 31
            WHEN 2 THEN 32
          END,
    salary = CASE id
               WHEN 1 THEN 60000
               WHEN 2 THEN 65000
             END
WHERE id IN (1, 2);

BEGIN TRANSACTION;
UPDATE employees SET age = 31, salary = 60000 WHERE id = 1;
COMMIT;

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData

engine = create_engine('sqlite:///example.db')
metadata = MetaData()

employees = Table('employees', metadata,
                 Column('id', Integer, primary_key=True),
                 Column('name', String),
                 Column('age', Integer),
                 Column('salary', Integer))

with engine.connect() as conn:
    update_stmt = employees.update().\
        where(employees.c.id == 1).\
        values({'age': 31, 'salary': 60000})
    conn.execute(update_stmt)