K
K
Konstantin2018-10-12 22:07:35
MySQL
Konstantin, 2018-10-12 22:07:35

What is a real use case for SQL/MySQL views?

What is a real use case for SQL/MySQL views?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Saboteur, 2018-10-12
@saboteur_kiev

Yes, full. Really you did not face business logic?
For example, granting limited access - in order not to give access to an entire table, you give access to a view that can be a selection from this table with a filter.
For example, delimitation of business logic and hardware (to speed up work) - you can select the necessary data from two different tables, and the tables themselves are stored in different types of tables and different types of data files.
And indeed, there can be many examples. Just read any article.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question