Nils Valentin [EMAIL PROTECTED] wrote:
I have some questions about temporary tables. I would appreciate any replies:
I created a temporary table f.e. like this:
mysql create temporary table temp SELECT * FROM relations;
Query OK, 4 rows affected (2.35 sec)
Records: 4 Duplicates: 0
WOW Victoria,
thats a good explanation. That makes many things clearer now.
Thank you very much.
However, when not having the set the tmpdir variable were are the temporary
tables stored ? (I searched the whole harddisc) I assume in this case that
they must be stored in the memory, is that
Nils Valentin [EMAIL PROTECTED] wrote:
WOW Victoria,
thats a good explanation. That makes many things clearer now.
Thank you very much.
However, when not having the set the tmpdir variable were are the temporary
tables stored ? (I searched the whole harddisc) I assume in this case
Hi Vitcoria,
Thank you for the response. No more questions about this, all systems clear
now ;-).
Thank you so much.
Nils Valentin
Tokyo/Japan
2003 6 25 21:18Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
WOW Victoria,
thats a good explanation. That makes many things
Hi MySQL Fans ;-),
I have some questions about temporary tables. I would appreciate any replies:
I created a temporary table f.e. like this:
mysql create temporary table temp SELECT * FROM relations;
Query OK, 4 rows affected (2.35 sec)
Records: 4 Duplicates: 0 Warnings: 0
When I do
mysql