RE: Temporary table question

2003-10-16 Thread Susan Ator
- Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 16:39 Subject: Re: Temporary table question > basically used to make queries easier running from within scripts

Re: Temporary table question

2003-10-16 Thread Director General: NEFACOMP
From: "Nitin" <[EMAIL PROTECTED]> To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 16:39 Subject: Re: Temporary table question > basically used to make queries easier running from within scripts. it could > be

Re: Temporary table question

2003-10-16 Thread Nitin
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