SQL SEVER 实现存在更新，不存在插入功能。

use SCADA_Other
begin
if (SELECT max( id ) id FROM kettle_log1 ) > (SELECT max( id ) id FROM kettle_log )

UPDATE
kettle_log
SET kettle_log.end_time=kettle_log1.end_time
FROM kettle_log,kettle_log1
WHERE kettle_log.id=kettle_log1.id AND kettle_log.create_time=kettle_log.end_time

INSERT INTO kettle_log(
	id,node,node_name,status,state,create_time,end_time
	)
SELECT
	a.id,
	a.node,
	a.node_name,
	a.status,
	a.state,
	a.create_time,
	a.end_time 
FROM
	kettle_log1 a,
	(SELECT max( id ) id FROM kettle_log) b 
WHERE
	a.id > B.id
end

replace into `TExT` (IP,ServerState) values('10.29.170.135',1)