I want to insert new data sets of my table "order" into another database (table "order2") if it fits some criteria. Is it possible to do something like this in HeidiSQL?
As you might see, I am new to this :) I created a new trigger and wrote the following:
*ON After insert BEGIN
INSERT IGNORE into NEW_DB.acquired_data.order2 values (SELECT TOP (1) * from THIS_DB.acquired_data.order where product in ('someting','something else') order by date desc)
I am not quite sure if I use the syntax of the trigger function correctly. I immediately get an error in Line 1 at "BEGIN" :-\
Any hint would be helpful!
Thanks a lot!