摘要： SQL WITH a as (SELECT id, row_number() OVER() rn FROM camera) UPDATE camera SET id = (SELECT rn FROM a WHERE camera.id = a.id); 什么是WITH子句 如果你想多次使用某个表， 阅读全文