Answer Posted / guest
Table contains all the row. View doesn't contain any data
but rather an SQL statement that is executed every time the
View is accessed. It provided row level security for
accessing information.
The downside is lost performance as compared to a Table
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What does blob mean in mysql?
What is a mysql view?
What is the password of mysql?
What are the functions of commit and rollback statements?
How do I clear a mysql database?
What are the difference between now and current_date in mysql?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
Can we save images in mysql database?
Where is the mysql config file?
What are the limitations of mysql?
How do I copy an entire mysql database?
How to create table show example
How to drop an existing view in mysql?
Is mysql workbench a dbms?
What is a crosstab query?