MySQL Database Management System > MySQL View

MySQL - View

28.2k

According to the mysql certification guide, views can be used to provide a summary that may include computations. Hide irrelevant data by using a WHERE clause to pick a set of rows. As a result of a merger or unification.

A view is a database object that doesn't have any data in it. Its contents are based on the table that serves as the foundation. It has the same rows and columns as a genuine table. In MySQL, a View is a virtual table that is produced by connecting one or more tables in a query. It works in the same way as the base table, but it doesn't have any data of its own.

  • MAKE A VIEW 'view name'" instructs MySQL to build a view object named 'view name' in the database.
  • The SQL statements to be packed in the MySQL Views are referred to as "AS SELECT statement." It can be a SELECT query that includes data from one or more tables.

To open, right-click a table in the Navigator pane's object browser and select Table Inspector from the context menu. The Table Inspector displays details about the table.

Learner's Ratings

4.3

Overall Rating

  • 61%
  • 27%
  • 2%
  • 0%
  • 10%

Reviews

A
Aish Dubey
5

Perfect for beginners and explained in Hindi

M
Mohsin Salim Kazi
5

Great for beginners

C
Chandan Kumar
5

very good

S
Saurabh Virkud
4

Thank you learnvern ..

V
Vikash Chaudhary
5

This site is very usefull for everyone.

V
vj tricks
5

This course is very good

S
Sanjeev Rana
5

Please provide course notes

A
Ankit Patel
5

Thank you learnvern and learnvern is best platfrom a lern a new skill. again thank you.

Y
Yadav Aakash
5

learnvern doing greate job...Thank you teacher's content team.

U
Utkarsh Chimote
5

Awesome really great teaching and this is good platform for we are poor peoples😍🤗

Show More
Recommended Courses
Course Content
Enroll For Free