「Findstyleno」:修訂間差異
跳至導覽
跳至搜尋
| (未顯示同一使用者於中間所作的 1 次修訂) | |||
| 第4行: | 第4行: | ||
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%' | ||
UPDATE ulstyleno JOIN ulmaker USING(style) SET remark = | |||
(SELECT CASE WHEN remark ='' THEN '日合' ELSE CONCAT(remark,';日合') END) WHERE fileno='E194236' AND remark NOT LIKE '%日合%' | |||
UPDATE ulstyleno JOIN ulmaker USING(style) SET remark = | |||
(SELECT CASE WHEN remark ='' THEN 'LAPPUSA'ELSE CONCAT(remark,';LAPPUSA') END)WHERE fileno = 'E100338'AND remark NOT LIKE '%LAPPUSA%' | |||
</SQL> | </SQL> | ||
於 2016年1月30日 (六) 09:44 的最新修訂
更新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 '%日合%'
UPDATE ulstyleno JOIN ulmaker USING(style) SET remark =
(SELECT CASE WHEN remark = THEN 'LAPPUSA'ELSE CONCAT(remark,';LAPPUSA') END)WHERE fileno = 'E100338'AND remark NOT LIKE '%LAPPUSA%'
</SQL>