「Findstyleno」:修訂間差異
跳至導覽
跳至搜尋
| 第3行: | 第3行: | ||
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 ='TSK' WHERE fileno='E117926' AND remark NOT LIKE '%TSK%' | ||
UPDATE ulstyleno JOIN ulmaker USING(style) SET remark = | 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%' | (SELECT CASE WHEN remark ='' THEN 'SKT' ELSE CONCAT(remark,';SKT') END) WHERE fileno='E257581' AND remark NOT LIKE '%SKT%' | ||
</SQL> | </SQL> | ||
於 2016年1月30日 (六) 08:40 的修訂
更新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%'
</SQL>