drop database if exists test1;

create database test1;

use test1;

create sequence seq_a_id increment by 1 start with 1;

create table p (p_id integer, p_name varchar(128), p_first_name varchar(128));

create table archiv (a_id integer default nextval(seq_a_id), a_p_name varchar(128), a_p_first_name varchar(128), t timestamp default current_timestamp);

insert into p values

(1, 'Luo','Frank'),(2, 'Xe','Emma'),(3, 'Li','Anna'),(4, 'Lun','Serg'),(5, 'Xu','Nils'),(6, 'Ja','Ute'),(7, 'Jin','Mike'),(8, 'Lio','Carl'),(9, 'Lang','Kevin'),(10, 'Ling','Lisa'),(11, 'Fang','Frank'),(12, 'Feng','Emma'),(13, 'Tuo','Anna'),(14, 'Tua','Serg'),(15, 'Moa','Nils'),(16, 'Hua','Ute'),(17, 'Xufa','Mike'),(18, 'Lulu','Carl'),(19, 'Hoho','Kevin'),(20, 'Tata','Lisa');

DELIMITER $$

CREATE TRIGGER tr_upd

BEFORE UPDATE on p

FOR EACH ROW

BEGIN

INSERT INTO archiv(a_p_name, a_p_first_name) VALUES(old.p_name, old.p_first_name);

END;

$$

DELIMITER ;

MariaDB [test1]> update p set p_first_name='Yunxi' where p_id=1;

ERROR 2013 (HY000): Lost connection to MySQL server during query