Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Nils Valentin
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:18、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > WOW Victoria, > > > > thats a good explanation.

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Victoria Reznichenko
"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 thi

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Nils Valentin
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 r

Re: Temporary tables - MySQL 4.1 alpha

2003-06-25 Thread Victoria Reznichenko
"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 Duplicate

Temporary tables - MySQL 4.1 alpha

2003-06-24 Thread Nils Valentin
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>