2022年7月18日
WITH ... UPDATE
摘要： 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); 阅读全文
posted @ 2022-07-18 18:17 develon 阅读(32) 评论(0) 推荐(0) 编辑