mysql - Problems with mariadb create trigger

Question

I have 2 tables (tasks - where adding new tasks with user phone and his company id and tenant_phones_comp - where i add only 2 col: user phone and user company id) and i try to create a trigger at mariadb server. Trigger must insert row to tenant_phones_comp after inserted new line at tasks and if phone and company_id of that new task is not exists in tenant_phones_comp table insert them from new record in tasks. I have problem when i try to create triger. example here

Answer 1

等待大神答复