Shulou(Shulou.com)06/01 Report--

This article shows you the role of mysql view, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

What is the purpose of the mysql view

1. Improve reusability, like a function. If you want to obtain name of user and name of goods frequently

Select a.name as username, b.name as goodsname from user as a, goods as b, ug as c where a.id=c.userid and c.goodsid=b.id

two。 Refactoring the database without affecting the running of the program

3. Improve security performance. Different views can be set for different users, for example, users can only get name and age data of user table, but not sex data.

Create view other as select a.name, a.age from user as a

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The above is what the mysql view does, and have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.