尝试这个：
UPDATe table SET column = 'X1' WHERe id IN(SELECT id FROM (SELECt id FROMtable WHERe column = 'X' LIMIT 2) as u);
然后
UPDATe table SET column = 'X2' WHERe id IN(SELECT id FROM (SELECt id FROMtable WHERe column = 'X' LIMIT 4) as u);
尝试这个：
UPDATe table SET column = 'X1' WHERe id IN(SELECT id FROM (SELECt id FROMtable WHERe column = 'X' LIMIT 2) as u);
然后
UPDATe table SET column = 'X2' WHERe id IN(SELECT id FROM (SELECt id FROMtable WHERe column = 'X' LIMIT 4) as u);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
