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 |
What is mysql slow query?
How to use sum function in where clause in mysql?
How do I start mysql in mysql workbench?
Write a query to count the number of rows of a table in mysql.
How many triggers are possible in mysql?
How do I start mysql manually?
what is mysql optimization in brief?
What is the password of mysql?
How to check server status with 'mysqladmin'?
What is the use of procedure in mysql?
Where is mysql used?
How do I edit a table in mysql?