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 is data types in mysql?
Write a query to stop mysql in unix
what is the default port for mysql server? : Mysql dba
Is mysql a good database?
What is the difference between char and varchar?
How to validate email addresses in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How internally data stores in MyISAM and INNODB table types?
What is cast in mysql?
How to drop an existing index in mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What does mysql flush tables do?
What is the purpose of using timestamp data type?
What is mysql cursor?
Is mysql a odbc?
