Results 1 to 3 of 3
Thread: mySQL Views?
Feb 11, 2009, 02:19 #1
This tutorial explains what VIEWS are and how are they created.
My Question is that why do we need VIEWS for? Why cannot we use the normal SELECT command and fetch records directly from the main table instead of creating a VIEW first and then display records?
Feb 11, 2009, 02:29 #2
My Question is that why do we need VIEWS for
- Join Date
- Aug 2007
- 0 Post(s)
- 0 Thread(s)
I've seen 2 usage of views:
1) to give read access to certains datas for third party without giving full access on the db nor giving the schema details
2) on complicated queries, a DBA craft the view, and the developers can use that view without worrying about the 12 tables that are joined and the conditions of those joins.
For me, it's mostly case 2 now, as I work as DBA in a team of 3, and chew up some work for the winform/asp teams when they need to have access to something a bit more complicated that "select x from tbl where y=z"
Feb 11, 2009, 03:11 #3
That answered my query