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" <[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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
