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
How many columns can you create for an index?
How to show all tables with 'mysql'?
What are the different column comparison operators in mysql?
How do I switch users in mysql?
What are the technical features of MySQL?
How to Change a users password from unix shell.
What is sharding in mysql?
What is blob datatype in mysql?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is clob in mysql
How do I quit mysql?
What is foreign key in mysql?
How to shutdown mysql server?
Can foreign key have duplicate values?