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

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.

How to implement views in mysql 4.12 version

2005-05-23 Thread Dayakar
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. Please give me solutions at the earliest as

Re: Views in MYSQL

2003-10-13 Thread Ken Menzel
Hi, - Original Message - From: <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 5:52 AM Subject: Re: Views in MYSQL > What about when the script uses persistent connection

Re: Views in MYSQL

2003-10-13 Thread Nitin
then who said, you cant delete temporary tables Nitin - Original Message - From: <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 3:22 PM Subject: Re: Views in MYSQL

Re: Views in MYSQL

2003-10-13 Thread minky
Hi - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 10:42 AM Subject: Re: Views in MYSQL > I'm not talking about storing data into temporary tables for ever, but for &

Re: Views in MYSQL

2003-10-13 Thread Nitin
ginal Message - From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 2:29 PM Subject: Re: Views in MYSQL > In article <[EMAIL PROTECTED]>, > "Nitin" <[EMAIL PROTECTED]> writes: > > > if you are

Re: Views in MYSQL

2003-10-13 Thread Nitin
: "Timotius Alfa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 7:48 AM Subject: Views in MYSQL > > If views are not supported in MYSQL, is there any ways to replace it...I change database from Access to MYSQL, so I need utility such

Views in MYSQL

2003-10-12 Thread Timotius Alfa
If views are not supported in MYSQL, is there any ways to replace it...I change database from Access to MYSQL, so I need utility such as queries in Access. thanks *8 Views are not supported in MySQL along with many more feature included in the ANSI SQL 99 standard

Re: Views in MYSQL

2003-10-11 Thread Victoria Reznichenko
"Timotius" <[EMAIL PROTECTED]> wrote: > > Pls help me, how to create views in mysql. > > there isn't menu for views in mysql such as SQL Server 2000 ? Views currently are not supported in MySQL: http://www.mysql.com/doc/en/ANSI_diff_Views.html -- For

Re: Views in MYSQL

2003-10-11 Thread Nitin
; <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 12:53 PM Subject: Views in MYSQL > > Pls help me, how to create views in mysql. > > there isn't menu for views in mysql such as SQL Server 2000 ? > > thx > > -

Views in MYSQL

2003-10-11 Thread Timotius
Pls help me, how to create views in mysql. there isn't menu for views in mysql such as SQL Server 2000 ? thx Timotius, [EMAIL PROTECTED] +62-31-531-2358 ext. 205 -- MySQL General Mailing List For