1.

What are MySQL “Views”?

Answer»

In MySQL, a view consists of a set of rows that is returned if a particular query is executed. This is ALSO known as a ‘virtual table’. VIEWS make it easy to retrieve the way of making the query available VIA an alias. 
The advantages of views are:

  • Simplicity
  • Security
  • Maintainability


Discussion

No Comment Found

Related InterviewSolutions