raindropz12 Posted April 9, 2011 Share Posted April 9, 2011 May I know when do we need to create a view? What is the purpose of a view? Thanks in advanced. Link to comment https://forums.phpfreaks.com/topic/233179-about-views/ Share on other sites More sharing options...
php.ajax.coder Posted April 9, 2011 Share Posted April 9, 2011 Views have the following benefits: * Security - Views can be made accessible to users while the underlying tables are not directly accessible. This allows the DBA to give users only the data they need, while protecting other data in the same table. * Simplicity - Views can be used to hide and reuse complex queries. * Column Name Simplication or Clarification - Views can be used to provide aliases on column names to make them more memorable and/or meaningful. * Stepping Stone - Views can provide a stepping stone in a "multi-level" query. For example, you could create a view of a query that counted the number of sales each salesperson had made. You could then query that view to group the sales people by the number of sales they had made. http://www.learn-sql-tutorial.com/Views.cfm Found this hopes it helps Link to comment https://forums.phpfreaks.com/topic/233179-about-views/#findComment-1199460 Share on other sites More sharing options...
raindropz12 Posted April 10, 2011 Author Share Posted April 10, 2011 more examples please.. thank you. Link to comment https://forums.phpfreaks.com/topic/233179-about-views/#findComment-1199549 Share on other sites More sharing options...
fenway Posted April 19, 2011 Share Posted April 19, 2011 more examples please.. thank you. Why? Link to comment https://forums.phpfreaks.com/topic/233179-about-views/#findComment-1203428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.