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. As anyway after the connection > to your MySQL server is closed, temporary tables no more remain there. So > you can just use those tables from within a single script, to help you make > your queries easier. What about when the script uses persistent connections, these Temp Tables would never go away and each new connection create a new Temp Table. Therefore if you are operating a heavy load web site, the chances are you could easily run out of disk space. Temp Tables are not a substitute for Views and were never meant to be. The people at MySQL are more concerned about speed than they are about standards compilence. Therefore, any feature which protentially has an affect on performance will not get implemented. A perfect example of this is Referential Integrity Regards Minky > > and for procedures, those are supported in ver 3.23 also, with select > statements, the syntax is: > > select field-list > from tablename > procedure procedurename > > this way, data selected from the select statement will be passed to that > procedure to work upon. > > > ----- Original 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 to be used on web), you can use your scripts to create tamporary > > > tables and use them as views ... > > > > Nope. Temporary tables don't reflect changes in the underlying > > tables, contrary to views. > > > > > ... else you can write procedures for that > > > purpose, depending on your need. > > > > Except that MySQL will not support stored procedures until version 5.0. > > > > > > -- > > 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]
