MySQL CREATE VIEW PHP
- PHP Tutorial
- What is PHP
- Install PHP
- PHP Example
- PHP Echo
- PHP Print
- PHP Variables
- PHP $ and $$ Variables
- PHP Constants
- Magic Constants
- PHP Data Types
- PHP Operators
- PHP Comments
- PHP Boolean
- PHP is_bool() function
- PHP Integer
- PHP is_int() function
- PHP Float
- PHP is_float Function
- PHP Compound Types
- PHP Special Types
- PHP is_null() function
- PHP If Else
- PHP Switch
- PHP For Loop
- PHP While Loop
- PHP do while loop
- PHP Break
- PHP Functions
- PHP Parameterized Function
- PHP Call By Value
- PHP Call By Reference
- PHP Default Argument Values Function
- PHP Variable Length Argument Function
- PHP Recursive Function
- PHP Arrays
- PHP Indexed Array
- PHP Associative Array
- PHP Multidimensional Array
- PHP Array Functions
- PHP String
- PHP String Functions
- PHP Math functions
- PHP Form Handling | GET and POST method
- PHP Include File
- PHP Cookie
- PHP Session
- PHP File Handling
- PHP Open File
- PHP Read File
- PHP Write File
- PHP Append to File
- PHP Delete File
- PHP File Upload
- PHP Download File
- PHP Mail
- PHP MySQL Connect
- PHP MySQL Create Database
- PHP MySQL Create Table Example
- PHP MySQL Insert Record
- PHP Prepared Statements
- PHP MySQL Update Record
- PHP MySQL Delete Record
- PHP MySQL Select
- PHP MySQL Order By
- PHP Limit Data MySql
- PHP JSON
- PHP XML Parsers
- PHP SimpleXML Parser
- PHP SimpleXML - Get Node/Attribute Values
- PHP XML Expat Parser
- PHP XML DOM Parser
- PHP - AJAX intro
- MySQL CREATE VIEW
MySQL CREATE VIEW
MySQL CREATE VIEW
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
CREATE VIEW Syntax
SELECT column1, column2, ...
FROM table_name
WHERE condition;
Note: A view always shows up-to-date data! The database engine recreates the data, using the view's SQL statement, every time a user queries a view.
SQL CREATE VIEW Examples
Syntax of CREATE VIEW
SELECT column1, column2, ...
FROM table_name
WHERE condition;
Syntax of Create View and with JOIN CONDITION
Syntax of CREATE VIEW
SELECT column1, column2, ...
FROM table_name
JOIN table_name ON condition
WHERE condition;
The following SQL creates a view that shows all customers from the USA:
Example
SELECT CustomerName, ContactName
FROM Customers
WHERE Country = "USA";
We can query the view above as follows:
Example
SQL CREATE OR REPLACE VIEW
SQL CREATE OR REPLACE VIEW Syntax:
SELECT column1, column2, ...
FROM table_name
WHERE condition;
The following SQL adds the "City" column to the "customers_of_usa" view:
Example
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "USA";
SQL DROP VIEW
SQL DROP VIEW Syntax
The following SQL drops the "customers_of_usa" view:
Example
Download free E-book of PHP
#askProgrammers Learn Programming for Free
Join Programmers Community on Telegram
Talk with Experienced Programmers
Just drop a message, we will solve your queries
