INSERT INTO `TSE:AC` (date, stockId, macdSignal, macd, macdHistogram, macdIsAsOfClose) VALUES ('2007-01-09', 2191, -0.0991, 0.0500, 0.1491, 1) ON DUPLICATE KEY UPDATE macdSignal = VALUES(macdSignal), macd = VALUES(macd), macdHistogram = VALUES(macdHistogram), macdIsAsOfClose = VALUES(macdIsAsOfClose); $VAR1 = 1;