MySQL Bugs: #4045: need view support

Bug #4045	need view support
Submitted:	7 Jun 2004 22:52	Modified:	27 Oct 2004 20:07
Reporter:	Larry Edwards	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Windows (XP or Lynux ..doesn't matter)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
To me, the current lack of view support on MySQL is a deciding factor in using a different database server for creating complex web applications.  Although there are always "work-arounds", doing so more than doubles development time.

How to repeat:
N/A

Suggested fix:
need view support.  Many times in creating complex web/app pages we use different look-ups for different roles. and thus having the ability to create views to do this as well as creating aliases to column names allows a developer much more flexibility in programming.

Views are available as of MySQL 5.0.1, which is available for download from
http://dev.mysql.com/

Thanks.