多條數(shù)據(jù)更新,
UPDATE 不支持 別名, INSERT 支持別名
UPDATE user SET
age = CASE id
WHEN 1 THEN '16'
WHEN 2 THEN '15'
END,
name = CASE id
WHEN 1 THEN 'tom'
WHEN 2 THEN 'jim'
END
WHERE id IN (1,2) AND id1 IN (11,22)
聯(lián)合查詢(xún)
SELECT
B.* from T_DB_EXPRESS_APP_ORDER as A
LEFT OUTER JOIN
T_DB_EXPRESS_APP as B
on
A.userid = B.userid
AND A.appId = B.appId
WHERE A.userid = '099921'
AND (B.type = '1' OR B.type = '2')
