2006-12-03 20:56:24 · 3 answers · asked by hjkhkjfkcjhv 1 in Computers & Internet ➔ Programming & Design
every rdbms gives this option. this is basically to shield users from accessing data directly from the table.
- Advantages
a. views are faster, only allow you to select.
b. do not add up any pressure onto the tables straight away.
c. more than one table can fetch data into views.
d. there are several types of views as your provided by databases.
2006-12-03 21:07:14 · answer #1 · answered by juljulabie 3 · 0⤊ 0⤋
Views are a way to create virtual tables based on our db.
Views are used to watch our data in a way that could be slightly different from the real structure of the database. You can, for example, make a specific user see only few columns of your table and hide others.
2006-12-04 05:20:52 · answer #2 · answered by andrea_mil83 1 · 0⤊ 0⤋
we are using view in mysql to tack a copy of the table.
2006-12-04 05:08:05 · answer #3 · answered by ganboo 1 · 0⤊ 0⤋