Please refer these links for simple understanding https://www.w3schools.com/sql/sql_view.asp http://www.mysqltutorial.org/create-sql-views-mysql.aspx https://www.guru99.com/views.html1 Sagar Lad 296 6k 314.9k 3
In SQL, a view is a virtual table based on the result set of an SQL statement.The CREATE VIEW command creates a view.The following SQL creates a view that selects all customers from Brazil:ExampleGet your own SQL Server CREATE VIEW [Brazil Customers] AS SELECT CustomerName, ContactName ...
SQL Updating a View A view can be updated with theCREATE OR REPLACE VIEWstatement. SQL CREATE OR REPLACE VIEW Syntax CREATEORREPLACEVIEWview_nameAS SELECTcolumn1,column2, ... FROMtable_name WHEREcondition; The following SQL adds the "City" column to the "Brazil Customers" view: ...
FROMtable_name WHEREcondition; Note:A view always shows up-to-date data! The database engine recreates the view, every time a user queries it. MySQL CREATE VIEW Examples The following SQL creates a view that shows all customers from Brazil: ...