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 are the technical features of MySQL?
How do I change the max connection in mysql?
What is difference between pdo and mysqli?
What is the difference between a heap table and temporary table?
How do I kill a mysql connection?
What is heap table?
Write a query to fetch duplicate records from a table using mysql?
How can we optimize stored procedure?
How do I run mysql on a mac?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
Is mysql a free database?
how can you test for null values in a database? : Mysql dba
How do I restart mysql on windows?
How do I start mysql from command line?
What is action query?