INSERT ¿Í UPDATE ±¸¹®À» ÇÑ°³ÀÇ Äõ¸®¸¦ ÀÌ¿ë
INSERT ½Ã DUPLICATE KEY ¿¡·¯°¡ ¹ß»ýÇϸé UPDATE ¸í·É¾î ¼öÇà
¡Ø INSERT XXX ON DUPLICATE KEY UPDATE ´Â MySQL 4.1.0 ºÎÅÍ Áö¿øµÇ¸ç ÀÌÇϹöÀü¿¡¼´Â Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
mysql> insert into TB_TRAFFIC (ymd, ip, octets, gbytes, mbitps) values ( '20131110', 'XXX.XXX.XXX.XXX', '2262700', 0.2 , 1 ) on DUPLICATE KEY update octets='2262700';
ERROR 1064 (HY000): You have an error in your SQL syntax near 'on DUPLICATE KEY update octets='2262700'' at line 1