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

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

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

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread Duncan Hill
) are implemented in the 5.0 version of MySQL Server. Views are available in binary releases from 5.0.1 and up. See Chapter 21, Views. Migrating, and then reading the documentation and trying to learn how things work is usually a bad idea. -- MySQL General Mailing List For list archives: http

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread mfatene
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 implemented in the 5.0 version of MySQL Server. Views are available in binary releases from 5.0.1 and up. See Chapter 21, Views

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 as queries in Access. thanks

Re: Views in MYSQL

2003-10-13 Thread Nitin
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 using mysql on web (which is the most possible case, as MySQL is created

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 the better accessibility inside the scripts

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 Hi - Original Message - From: Nitin

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 much cut What about when the script uses persistent connections, these Temp Tables would never go away

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

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 list

Re: Views in MYSQL

2003-10-11 Thread Nitin
MySQL doesn't support views as of now. It's a feature MySQL is missing for long time. For more information have a look at http://www.mysql.com/doc/en/ANSI_diff_Views.html Nitin - Original Message - From: Timotius [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Saturday, October 11

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 technical support contracts, goto https