What is the difference between a Table and a View?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jagdish prajapati
Table is Physical Stored. but View is logical or virtual
Stored.
Is This Answer Correct ? | 9 Yes | 1 No |
How do you create a primary key?
Is mysql a server?
How do I find users in mysql?
How can I connect mysql database?
What do you understand by mysql terminal?
Why phpmyadmin is used for mysql?
What is session variable in mysql?
How to enter boolean values in sql statements?
What is the maximum number of records in mysql table?
What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?
What are the limitations of mysql?
What is delimiter in mysql stored procedure?