MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLe orders (product_id int)
CREATE TABLE `orders_log` (
    `log_id` INTEGER NOT NULL AUTO_INCREMENT,
    `action` VARCHAR(255) DEFAULT NULL,
    `table_name` VARCHAR(255) DEFAULT NULL,
    `action_time` TIME DEFAULT NULL,
    `product_id` INTEGER NOT NULL,
    PRIMARY KEY (`log_id`)
    );
CREATE TRIGGER addrowlog
AFTER INSERT ON orders
FOR EACH ROW
BEGIN 
    insert into orders_log ( `action`, `table_name`, `action_time`, `product_id`)
    VALUES  ( 'insert', 'orders', NOW(), new.product_id);
END
INSERt INTO orders VALUEs(1)
SELECT * FROM orders_log


log_id
action
table_name
action_time
product_id


1
insert
orders
12:10:43
1