How to declare variable in trigger with MySQL?

How do I do this MYSQL trigger between 2 tables?

• For example If I had 2 columns on TABLE1 called "id" and "count" that contains numbers, when those numbers reach 50 or over then I want the trigger to update a column called "reached" on TABLE2 with "yes" along with its id, in the id column How can it be done? Thanks

• Answer:

  Try something along these lines:- CREATE TRIGGER ReachedTrig AFTER INSERT, UPDATE ON Table1 FOR EACH ROW BEGIN INSERT INTO Table2 SELECT 'Yes' AS Reached, id = Table1.id FROM Table1 WHERE `Count` >= 50 END; You might need to tweak the syntax a little, I'm more used to MSSQL I'm afraid, I'm a bit rusty on MySQL... :)