MySQL Tutorial View 18 codes

  1. Home
  2. MySQL Tutorial
  3. View
1 A few things arent allowed in a query that defines a view
2 Adding ORDER BY to the Joined Table View
3 ALTER VIEW statement
4 Check Options
5 Creating a view by joining two tables
6 Creating a View with Joined Tables
7 Creating a View with Specified Column Names
8 Creating a View with UNION
9 Creating an Updatable View
10 Creating Views
11 Defining Views of Views
12 DESCRIBE statement works on a view just as it does on a table
13 Removing Views
14 Using a GROUP BY Clause to Create a View
15 Using a GROUP BY Clause to Create a View with ALGORITHM = TEMPTABLE
16 Using EXPLAIN
17 Using HAVING with GROUP BY to Create a View
18 You can use the SHOW CREATE VIEW command to view the entire CREATE syntax used when creating a view