Mysql Query - Insert or Update

 

INSERT INTO stat_traffic_monthly 
VALUES('2024-07-01 00:00:00', 'AP10', 0, 63334484, 4024465, 49168, 46573, 0, 0, 0, 3)
ON DUPLICATE KEY UPDATE
	tx_octet=tx_octet+63334484, rx_octet=rx_octet+4024465, tx_packet=tx_packet+49168, rx_packet=rx_packet+46573, tx_error=tx_error+0, tx_dropped=tx_dropped+0, rx_dropped=rx_dropped+3
;

 

 

https://www.atlassian.com/data/admin/how-to-insert-if-row-does-not-exist-upsert-in-mysql

 

Insert시 Duplicated key 에러 발생하면 Update함