Refresh MySQL views?

Views do not need to be refreshed when the data changes. When you query them they will fetch the newest data.

They might need to be recreated if your table structure changes:

The view definition is “frozen” at creation time, so changes to the underlying tables afterward do not affect the view definition. For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view.

Source


I was working on a project and my view didn't show new data because I was trying to make a join on a NULL field to another table. So I just updated the new data with a correct value for that field and it worked.