MrAntunes
10/30/2017 - 3:15 PM

insert or update line && returns ID

insert or update line && returns ID

INSERT INTO tb_sgt_rt_complaint(id_rt_destiny, obs, id_user_create)
	VALUES(p_id_rt_destiny, p_obs, p_id_user)
	ON DUPLICATE KEY UPDATE id_rt_complaint = LAST_INSERT_ID(id_rt_complaint), obs = p_obs, id_user_change = p_id_user;

	SELECT LAST_INSERT_ID() AS lastid;