Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 
Buy SQL » Articles for 18.12.2011

MySQL views, creation and usage

Author: rootsql on 18-12-2011, 21:57


A view – is a database object based on a SELECT query that has tables or other views specified inside it. In other words, this is a named query that is stored in a database as a separate object. Unlike a table, a view is not a data storage.

When referring to a view, we just receive data that is returned by the internal SELECT query.