Trigger phpmyadmin

Creating tables for the triggers:

CREATE TABLE logitabel(
    id INT PRIMARY KEY AUTO_INCREMENT,
    toiming TEXT,
    aeg DATETIME,
    autoAndmed TEXT
);

CREATE TABLE Avtoregistr(
    id INT PRIMARY KEY AUTO_INCREMENT,
    aeg DATETIME,
    owner TEXT
)

TRIGGER FOR INSERT:

Creating a trigger for Avtoregistr inserting input it as a log
Before insert command executes from Avtoregistr table, the trigger creates a query what it contained from inserting command.

SQL code to add data to the table avtoregistr

insert into avtoregistr(aeg, owner)
VALUES ( (NOW()), 'Vadim Serv' ); 

TRIGGER FOR DELETE:

Creating a trigger for Avtoregistr Deletion, input it as a log
Before deletion command executes from Avtoregistr table, the trigger creates a query what was deleted.

delete from avtoregistr where id = 1;

TRIGGER FOR UPDATE:

Creating a trigger for Avtoregistr modification, input it as a log
After command executes from Avtoregistr table, the trigger creates a query show what was updated from old data to new data.

UPDATE avtoregistr SET owner = 'Val tor' WHERE ID=2