CREATE TABLE `table1` (

 `id` int(11) DEFAULT NULL,

 `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL

) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=1;

CREATE TABLE `table2` (

 `id` int(11) DEFAULT NULL,

 `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL

) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=1;

CREATE TRIGGER `table1_before_insert` BEFORE INSERT ON `table1`

 FOR EACH ROW BEGIN

	insert into table2(`id`, `name`) values (NEW.`id`, NEW.`name`);

END

import mariadb

conn=mariadb.connect(user="test", database="test")

cursor=conn.cursor()

vals = [(1,'John'), (2,'Smith'), (3,'Carol')]

cursor.executemany("INSERT INTO table1 VALUES (?,?)", vals)

cursor.execute("SELECT * FROM table1")

rows= cursor.fetchall()

print(rows)