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 3y Hi Dipa, Check this blog. It will be useful for more info : https:...
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: ...