ON DUPLICATE KEY UPDATE

$insertsql="INSERT INTO fac_SensorReadings
SET DeviceID=$dev->DeviceID,

Temperature=$temp, Humidity=$humidity,
LastRead=NOW() ON DUPLICATE KEY

UPDATE Temperature=$temp,
Humidity=$humidity, LastRead=NOW();";
原文地址:https://www.cnblogs.com/hehexu/p/8320105.html