Re: How to implement views in mysql 4.12 version

2005-05-23 Thread mfatene
Hi, Waiting for v5 for views, you can prepare them in inline view (subqueries): select ... from (select ...) Mathias Selon Duncan Hill <[EMAIL PROTECTED]>: > On Monday 23 May 2005 20:01, Dayakar wrote: > > Please give me solutions at the earliest as mirgration from oracle to mysql > > is start

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread Duncan Hill
On Monday 23 May 2005 20:01, Dayakar wrote: > Please give me solutions at the earliest as mirgration from oracle to mysql > is started and i need to meet the solution as soon as possible. 4.1 does not support views. As documented in the online documentation: "Views (including updatable views) are

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread Paul DuBois
At 0:31 +0530 5/24/05, Dayakar wrote: Hello, I want a solution to implement the views in mysql 4.12 version. It is urgent. Earlier our database was oracle and our search of database is done using views. I want to implement the same in mysql 4.12 version. Does any one know how to do it. Plea

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread Jeff Smelser
On Monday 23 May 2005 02:01 pm, Dayakar wrote: > I want a solution to implement the views in mysql 4.12 version. It is > urgent. Earlier our database was oracle and our search of database is done > using views. I want to implement the same in mysql 4.12 version. You need version 5.0.4.. http://de