I am trying to create a trigger that updates one field in a table different from the one being updated/inserted.
My create trigger code looks like this:
CREATE TRIGGER before_insert_ddsw BEFORE INSERT ON `ddsw` FOR EACH ROW SET products.count - products.count +1;
When I try to create this I get an error #1193 - Unknown system variable 'count' but there is definately a field called 'count' in the product table.
What am I missing here?