Open Source Tutorials - Open Source Training
Open source training & tutorials from experienced, passionate people
chrome icon firefox icon ie icon opera icon safari icon Sings in these Browsers
A- A A+

By A Web Design

Welcome, Guest
Username Password: Remember me

Difference between Table and View
(1 viewing) (1) Guest
All your queries regarding
MySQL Installation,
Learning MySQL DBA,
and tonnes more... will be solved in this forum
  • Page:
  • 1
TOPIC:

Difference between Table and View

Difference between Table and View 1 year, 9 months ago #125

  • kennedy
  • OFFLINE
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
What is the difference between the Table and View

Re:Difference between Table and View 1 year, 9 months ago #127

  • dhuruv
  • OFFLINE
  • Senior Boarder
  • Posts: 60
  • Karma: 0
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.

Re:Difference between Table and View 1 year, 9 months ago #132

  • palak
  • OFFLINE
  • Senior Boarder
  • Posts: 55
  • Karma: 0
Table is Physical Stored but View is logical or virtual Stored.
  • Page:
  • 1
Time to create page: 1.35 seconds
OSV Newsletter


Receive HTML?

NOTE: To prevent subscription to the OSV newsletter, uncheck the checkbox above.
Guest Blog for OSV
Free Ebook Download