MySQL 更新数据：找到最贵产品并修改供应商

UPDATE products SET supplier = 'CCNU' WHERE price = (SELECT MAX(price) FROM products);

-- 查看是否成功 SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products);