How to create view in MySQL database

• Create view Statement in MySQL

  CREATE VIEW employeeNames as select EmpID, EmpName from employee;
  

  Output

  mysql> CREATE VIEW employeeNames as select EmpID, EmpName from employee;
  Query OK, 0 rows affected (0.02 sec)
  

  You can use above statement to create a view in MySQL table.

• Employee table structure

  Create table statement to create Employee table.

  You can create the Employee table with columns EmpID, EmpName, Mobile, PresentAddress, Area, City, Country, Qualification and Email.

  CREATE TABLE Employee (
      EmpID INT PRIMARY KEY,
      EmpName VARCHAR(255),
      Mobile VARCHAR(20),
      PresentAddress VARCHAR(255),
      Area VARCHAR(255),
      City VARCHAR(255),
      Country VARCHAR(255),
      Qualification VARCHAR(255),
      Email VARCHAR(255)
  );
  

Back to code snippet queries related sql