参考和here
请考虑下列表格：

CREATE TABLE Employees (
  EmployeeID INT,
  LastName varchar(20) NOT NULL,
  FirstName varchar(20) NOT NULL,
  Birthdate date 
);

create table Employees_audit (
  note varchar(255),
  inserted_record_dt datetime,
  EmployeeID int
);

您需要的触发器：

create trigger Insert_Employees_audit after insert on Employees
 for each row
 begin
 insert into Employees_audit (EmployeeID,note, inserted_record_dt) values (new.EmployeeID,'A new row is inserted',  now());
end

一些数据示例

insert into Employees values (1,'Test','Test','2000-01-01');

结果：

select * 
from Employees_audit;

           note         inserted_record_dt     EmployeeID
A new row is inserted   2022-11-21 10:01:34        1

https://dbfiddle.uk/KGa4ditu