Hi, If you desperately need Views/Triggers/Stored procedures. Then there is way to use some of them on MySQL if: 1. You can use Windows/MAC in your project (at least for the clients). 2. Amount of Data is not extremely large.
I have not tested this solution thoroughly, but it worked for me in one of my projects. Solution: 1. Create a new Database in MS Access. Import you MySQL table in MS Access using MyODBC. 2. Apply latest JET ( MS Access ) and MDAC service pack from Microsoft site. 3. Now you can create views on tables that were imported into access. Now, at the client end, instead of accessing MySQL through MyODBC, user applications can connect to MySQL through Ms Access (Using ODBC, ADO, JDBC and so on.....). In my project, views were required by a reporting tool. I created a view that used 5 tables and had proper where clauses in place. All the report development team had to worry about was a "Select * from ... " query ( and filling some parameters ). The MySQL database was not a large database. It had nearly half a million records. Performance of MySQL + MS Access was good. I did not test it with a really large database. This is more of a Hack, but it worked fine in the given situation. And fortunately, MS Access Driver is free of cost and included in most Windows installation. Regards, Shamit Verma http://www.vshamit.com ----- Original Message ----- From: "John Griffin" <[EMAIL PROTECTED]> To: "hemanth" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 9:09 PM Subject: RE: PL/SQL, Views, Functions, Proceedures Hi, PL/SQL is an Oracle proprietary language and can not be used. I know that the good people at MySQL are planning to add a language to MySQL but I do not think that there is a target release for this. Views, Functions and Procedures are also on the list of things to add to MySQL but I do not think that there is a timeline for these things. Adding anything to the execution path of an application, a database application for example, will naturally make it slower. That said, the people at MySQL have been very good at maintaining and in some cases improving the performance of the database so I would not worry about new features slowing the database. Hopefully someone from MySQL can also respond and give more information than I have. -----Original Message----- From: hemanth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:40 AM To: [EMAIL PROTECTED] Subject: PL/SQL, Views, Functions, Proceedures Hi, Why MySQL does not support PL/SQL, Views, Functions, Procedures, Sub queries. Will that be added in forthcoming MySQL version. If it above mentioned features are added will the database becomes slow. Pls. give me some information on this issue. Thanks in Advance. HEMANTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
