Ok, let me start off by saying I know almost nothing about triggers.
We have a large (local development) database that needs to be synced
with a remote (live) database from time to time. Rather than dumping
and reinstalling the database each time (as we are doing now), I want
to create a new table to keep track of the changes (so we can derive
queries from that). We are using 5.0.24a-community-nt. Here's the
SQL I tried... I keep geting a 1064 (Syntax error) error at
'INSERT'... Any ideas?
CREATE TRIGGER `universal`.`auth_in` AFTER INSERT ON
FOR EACH ...