ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨Ï¥Î SQL»yªk ON DUPLICATE KEY UPDATE

[µo°Ý] ¨Ï¥Î SQL»yªk ON DUPLICATE KEY UPDATE

¥»©«³Ì«á¥Ñ starry1314 ©ó 2017-12-29 17:07 ½s¿è

sql = "insert into Àç·~ÃB(³æ¸¹,½s¸¹,©m¦W)  select ³æ¸¹,½s¸¹,©m¦W from TMP_Àç·~ÃB t on duplicate key update  ½s¸¹ = t.½s¸¹,©m¦W = t.©m¦W;"
      
½Ð°Ý³o¼Ëªº¨Ï¥Î¤è¦¡¦³¤°»ò¿ù»~¶Ü?
¥¼©R¦W.png
2017-12-29 17:07

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD