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

Answer / jagdish prajapati

Table is Physical Stored. but View is logical or virtual
Stored.

Answer / shaik

-Table will have its own data,View doesnt have its own data.

-In Tables data stored Physically,In view its logiacally.

-we have tables of single type,but in views, Simply and
complex views.

Is mysql relational database?

0 Answers  

---

Is mysql free download?

0 Answers  

---

How do you concatenate strings in mysql?

0 Answers  

---

Is mysql a server?

0 Answers  

---

using primary can we relate two table, with out foreign key?

0 Answers  

---

What is procedural api?

0 Answers  

---

Is mysql free for enterprise?

0 Answers  

---

How to display odd rows in student table in mysql?

0 Answers  

---

Explain timestamp?

0 Answers  

---

How do I connect to mysql database?

0 Answers  

---

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

---

What is mysql good for?

0 Answers  

---