w1100n
This site is best viewed in Google Chrome
8/29/2019 10:33

EXPLAIN
UPDATE table0 w SET
 w.field0 ='foo'
WHERE 
 (w.key0,w.key1,w.) IN
 (
SELECT a.* FROM (
SELECT w1.key0,w1.key1,w1.key2
FROM table0 w1
WHERE w1.field0 IS NULL AND  w1.key2=0
LIMIT 10) AS a  );

EXPLAIN
UPDATE table0 w0
JOIN (SELECT *FROM table0 w1 WHERE w1.field0 IS NULL AND w1.key0=0 LIMIT 10) w2 
ON w0.key0=w2.key0 AND w0.key1=w2.key1 AND w0.key2=w2.key2 
SET w0.field0='foo'


<< Previous Posts Newer Posts >>
辽ICP备14012896