mysql 同一张表赋值

update tb_plo_artificialfactor b set cprefactornum=(SELECT cfactornum from (SELECT * FROM tb_plo_artificialfactor) a WHERE a.cstarttime< b.cstarttime
posted @ 2021-08-26 10:29  誓鼎  阅读(85)  评论(0)  编辑  收藏  举报