Error 1442: MySQL Error In phpMyAdmin related to triggers

QuestionsError 1442: MySQL Error In phpMyAdmin related to triggers
sethbeckerman5 Staff asked 5 years ago

I created this Trigger on a books table

The purpose of the trigger was to automatically set the values of the available copies to be the same as total copies after an insert is done.
When I tried an insert query on the table
MySQL said:

please how can this issue be solved?


View on Stack Overflow