basically used to make queries easier running from within scripts. it could be a good workaround for views, as you can create a temporary table to be used as a view, but it gets destroyed as the connection to your database closes. You can also use it as a good workaround for union, for older mysql version, which doesn't support union and for other functions you want to perform on some rows selected from multiple tables.
Enjoy Nitin ----- Original Message ----- From: "Susan Ator" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 7:39 PM Subject: Temporary table question > I would like to know the circumstances in which a temporary table would be > used. What is the rationale behind temporary tables? I have searched the > manual and the 'net but only find out information about creating or > manipulating them. > > Thanks, > > Susan > > -- > 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]
