JokerCatz
JokerCatz
UPDATE table SET uid = ELT(id, 2952, 4925, 1592) WHERE id IN (1,2,3) 這個更棒
Can
這個酷
JokerCatz
最後測試要用類似 UPDATE table SET val = ELT(FIELD(id,27,9,5,15,30,14,8,23,4,22,19,7,3,24,25,11),50,93,17,55,79,2,84,45,7,49,50,27,85,7,43,98) WHERE id IN (27,9,5,15,30,14,8,23,4,22,19,7,3,24,25,11)
載入新的回覆