Database-mysql View

A view is a virtual table (not a real one), which is essentially "fetching dynamic datasets from SQL statements and naming them", using "name" to get a result set, and using it as a table

One: Create a view

　CREATE VIEW viewname as select Tname from Table1,table2 where condition

 from student; Query OK, 0 rows affected (0.02 sec) MariaDB [test2]> show tables; +-----------------+| Tables_in_test2 |+-----------------+| A               | | b               | | student         | | Student2 in         Set (0.00 sec)

Two: Delete view

　Drop View ViewName

MariaDB [test2]> drop view student2; Query OK, 0 rows affected (0.00 sec) MariaDB [test2]> show tables; +-----------------+| Tables_in_test2 |+-----------------+| A               | | b               | | Student in          Set (0.00 sec)

Three: Modify the View

　Alter VIEW viewname as select Tname from Table1,table2 where condition

　　

 from A; Query OK, 0 rows affected (0.00 sec)

Database-mysql View