MySQL更新案例帮助

UPDATE  ae44SET     price =        CASE        WHEN ID = 'AT259793380' THEN     '500'        WHEN ID = 'AT271729590' THEN     '600'        WHEN ID = 'AT275981020' THEN     '700'        END

请注意，此查询将使用其他ID将记录的价格更新为

NULL

如果只想更新列表中的ID，请使用以下命令：

UPDATE  ae44JOIN    (        SELECT  'AT259793380' AS oldval, '500' AS newval        UNIOn ALL        SELECT  'AT271729590' AS oldval, '600' AS newval        UNIOn ALL        SELECT  'AT275981020' AS oldval, '700' AS newval        ) qON      ae44.id = q.oldvalSET     price = q.newval