Create and Drop view in MySQL

Dipa Mehta

6y1.2kDatabases & DBA

Kindly explain the view concept..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Puneet Kankar6y ago
Accepted answer
Hi Dipa,

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.

Watch given below video link for better understanding.

https://www.youtube.com/watch?v=VQpmOmZO2mo

We can create and drop view using below commands.

Create Command
CREATE VIEW view_name AS

SELECT column1, column2,column3, column4

FROM table_name

WHERE condition;
Drop Command
DROP VIEW view_name;
+2
geetha geetha4y ago
View is a virtual table. It is logical structure of the table it will used to retrieve data from one or more table.
Create View:
CREATE VIEW emp_view AS
SELECT empid, empname
FROM emp
WHERE empid>5;
select * from emp_view

Drop view:
Drop view view_name;

+1
satheesh d4y ago
Views can join and simplify multiple tables into a single virtual table. For example if the table consists of employee's name, gender, Id, salary column respectively. I want to give access to my accountant team about the employee details whose salary more than 50000 without exposing the salary details. I can create the view with the required details and then the access can be given to the accountant team. Not need to create seperate table for this.
CREATE View Employeelist
AS
SELECT NAME, GENDER FROM [assignment].[dbo].[EMPLOYEE]
WHERE SALARY>40000
+2
Sagar Lad5y ago
Hi Dipa,

Check this blog. It will be useful for more info : https://dev.mysql.com/doc/refman/8.0/en/drop-view.html
+1
Rajanikant Hawaldar6y ago
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.html
+2