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.
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]