这个语句用的比较多:INSERT INTO AggregatedData (datenum,Timestamp)VALUES ("734152.979166667","2010-01-14 23:30:00.000")ON DUPLICATE KEY UPDATETimestamp=VALUES(Timestamp)