As we know that while creating a view, providing the list of columns is optional. But if we are providing the name of the columns while creating the view then the number of names in the list of columns must be the same as the number of columns retrieved by the SELECT statement.
Example
The following example will illustrate by creating the views with column list −
mysql> Select * from student_detail;
+-----------+-------------+------------+
| Studentid | StudentName | address |
+-----------+-------------+------------+
| 100 | Gaurav | Delhi |
| 101 | Raman | Shimla |
| 103 | Rahul | Jaipur |
| 104 | Ram | Chandigarh |
| 105 | Mohan | Chandigarh |
+-----------+-------------+------------+
5 rows in set (0.17 sec)
mysql> Create view View_student_detail_columns AS SELECT Studentid,
StudentName FROM Student_Detail;
Query OK, 0 rows affected (0.10 sec)
登录后复制
在上面的代码中，我们给出了两列，并在运行查询以从视图中获取数据后，它将仅显示我们在创建视图时给定的列名。
mysql> Select * from View_Student_detail_columns;
+-----------+-------------+
| Studentid | StudentName |
+-----------+-------------+
| 100 | Gaurav |
| 101 | Raman |
| 103 | Rahul |
| 104 | Ram |
| 105 | Mohan |
+-----------+-------------+
5 rows in set (0.08 sec)
登录后复制
以上就是我们如何创建带有列列表的 MySQL 视图？的详细内容，更多请关注每日运维网(www.mryunwei.com)其它相关文章！
