Mariadb.
Пытаюсь создать простейший триггер:
create trigger replace_data
before insert on logs
for each row
begin
SET NEW.msg = replace(NEW.msg,'xxx','yyy');
end;
Получаю:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5