Answers for "insert of update row sql"

update after insert sql

-- SQL Server (update my_table2 after insert on my_table1)
CREATE TRIGGER trigger_name ON my_table1 FOR INSERT AS
BEGIN
    UPDATE my_table2 SET my_col_date = getdate() FROM my_table1 
END
-- Oracle (insert into log table after update on my_table)
CREATE OR REPLACE TRIGGER trigger_name AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
    INSERT INTO my_log_table (LOG_DATE, ACTION) VALUES (SYSDATE, 'Changed');
END;

insert or update sql query

INSERT INTO devices(id,name) 
VALUES 
   (4,'Central Printer') 
ON DUPLICATE KEY UPDATE name = 'Central Printer';