/*车间初始化*/ delete work_shop where site in ('1120', '1140', '1160'); insert into imes.work_shop (site, work_shop, description) select site, work_center, ......
update CLASS_RECORD_LINE x set start_TIME =(select min(CHECKTIME) from CHECKINOUT c where c.USERID = x.user_id and c.CHECKTIME between x.stand_start_t ......