Findstyleno
更新remark
<SQL> UPDATE ulstyleno JOIN ulmaker USING(style) SET remark ='TSK' WHERE fileno='E117926' AND remark NOT LIKE '%TSK%' UPDATE ulstyleno JOIN ulmaker USING(style) SET remark =
(SELECT CASE WHEN remark = THEN 'SKT' ELSE CONCAT(remark,';SKT') END) WHERE fileno='E257581' AND remark NOT LIKE '%SKT%'
UPDATE ulstyleno JOIN ulmaker USING(style) SET remark =
(SELECT CASE WHEN remark = THEN '日合' ELSE CONCAT(remark,';日合') END) WHERE fileno='E194236' AND remark NOT LIKE '%日合%'
</SQL>