「Findstyleno」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==更新remark== *UPDATE ulstyleno JOIN ulmaker USING(style) SET remark ='TSK' WHERE fileno='E117926' AND remark NOT LIKE '%TSK%'
 
Root​(留言 | 貢獻)
 
(未顯示同一使用者於中間所作的 3 次修訂)
第1行: 第1行:
==更新remark==
==更新remark==
*UPDATE ulstyleno JOIN ulmaker  USING(style)  SET remark ='TSK' WHERE fileno='E117926' AND remark NOT LIKE '%TSK%'
<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>

於 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>