PHP MySQL Tutorial

Views are like temporary tables. We can create views with combination of tables. Which is very useful to handle more than one tables at a time. Two important advantages of VIEWS are:

1]While updating tables, the related columns will be updated in views.
2]While updating views, the related columns will be updated in tables.

MySQL View Syntax:

CREATE VIEW viewname AS SELECT QUERY;