How to declare variable in trigger with MySQL?

Mysql trigger help please!!?

• I want a trigger that if row "ranged" has been updated or inserted into, then it copies that rows information into row "range" in the same table which is named "area". Is this possible? Table name = Area Row being updated = ranged Row that needs to take ranged and copy that information into is = range. so when "ranged" is updated it copies the value in that row into the column "range"

• Answer:

  yes, it's possible to create such coding via mentioning the are and the type of item.... Good luck!