Is there a way to create a trigger that will update an already existing view in mysql?

Asked Oct 11 '13 at 01:09

Active Oct 11 '13 at 17:02

Viewed 150 times

I have created a view but I would like to create a trigger that will replace the view each time either of the 2 tables that are used to create the view are updated.

Is there a solution for this or any suggestions on how to accomplish the same goal? Another solution would be to run a MySQL script at specific intervals to replace the view but I don't see a way to do that in MySQL.

Any help would be appreciated.

Using PMA.

asked Oct 11 '13 at 01:09

user2869250

What change do you want to make to the view? Surely the view will be updated as the tables are. – Oct 11 '13 at 01:10
You should read up on [materialized views](http://stackoverflow.com/questions/2534506/how-to-implement-materialized-view-with-mysql) – Mike B Oct 11 '13 at 17:15
Won't I need to refresh the view each time to reflect the new data? – user2869250 Oct 12 '13 at 00:57
It looks like you were correct Mike W...thanks for your help – user2869250 Oct 12 '13 at 03:01

Is there a way to create a trigger that will update an already existing view in mysql?

0 Answers0