t: Re: Temporary table question
Also, sometimes one needs to copy the content of a table in itself but
earlier versions of MySQL don't support something like
INSERT INTO some_table SELECT * FROM some_table /* the select table and
insert tables are not different */
So, you may create a temporary tabl
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
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
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 archive
