MySQL Creating trigger on view - Error 1347
MySQL does not support triggers on views.
The way to do this task is to make Koncerty
a table without keys, in order to then operate on it with trigger actions. It all worked out just as I wanted.
Also, making UNIQUE CONSTRAINTS
on records in tables does the job for the unique record, because it pops up an error when trying to add anything alike.