Create View « View « MySQL Tutorial






  1. MySQL Tutorial
  2. View
  3. Create View
9.1.Create View
9.1.1.A few things aren't allowed in a query that defines a view
9.1.2.Creating Views
9.1.3.Creating a View with Specified Column Names
9.1.4.Creating a View with Joined Tables
9.1.5.Adding ORDER BY to the Joined Table View
9.1.6.Using a GROUP BY Clause to Create a View
9.1.7.Using a GROUP BY Clause to Create a View with ALGORITHM = TEMPTABLE
9.1.8.Using HAVING with GROUP BY to Create a View
9.1.9.Creating a View with UNION








9.1.10.Creating a view by joining two tables