「Findstyleno」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==更新remark== *UPDATE ulstyleno JOIN ulmaker USING(style) SET remark ='TSK' WHERE fileno='E117926' AND remark NOT LIKE '%TSK%' |
|||
| 第1行: | 第1行: | ||
==更新remark== | ==更新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> | |||
於 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>