Why Register With OSV?

Join 5700+ of your peers

Get enriched. Access 1270+ quality tutorials right away on:

  • Joomla 2.5.X, 3.0.X
  • WordPress 3.5.X
  • Shopping Carts
  • E-Commerce Payment Gateways
  • PDFs for each tutorial - FREE for download
  • New topics and tutorials added weekly

FREE EBooks

FREE Templates

Member Login

Not a member yet? Sign Up!

Opensourcevarsity Logo
Tutorials & Training from experienced world class trainers
Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Open Source Varsity Forum
Open Source Community
MySQL Community

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
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Difference between Table and View

Difference between Table and View 2 years, 10 months ago #125

  • kennedy
  • OFFLINE
  • Senior Boarder
  • Posts: 46
  • Karma: 0
What is the difference between the Table and View
Reply Quote

Re:Difference between Table and View 2 years, 10 months ago #127

  • dhuruv
  • OFFLINE
  • Expert Boarder
  • Posts: 90
  • 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.
Reply Quote

Re:Difference between Table and View 2 years, 10 months ago #132

  • palak
  • OFFLINE
  • Expert Boarder
  • Posts: 101
  • Karma: 0
Table is Physical Stored but View is logical or virtual Stored.
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
Open Source Varsity Forum
Open Source Community
MySQL Community
Powered by Kunena  Protected by Spam Fighter
Time to create page: 1.29 seconds
O-S-V Free Templates

FREE HTML / Joomla / WordPress Templates For Download
Registration Required

CONNECT WITH US

Sitemap   |   Privacy Policy   |   MySQL(70)   |   Disclaimer   |   Reach Out To Us
Designed by Ivan Bayross & Meher Bala | Powered by Joomla
© 2013 All Rights Reserved.