How can i create a tomprary table in Mysql 1

[naceur]

Please help me.
1- How can i create a tomprary table in MySql?
2- How can i use 'count' with 'distinct' in MySql request?

 

[Cagliostro]

What is the truble?(if you have some). I think you should study SQL. John Fill

ivfmd@mail.md

 

[K1BBQ]

1 - you can create a table and then delete it later if you want. There's no special kind of temporary table that I know of.

Do you know the routine for a create?

create table "tablename" (in here you fill in the column names and data types you want).

If this is new to you, it would in fact be good to look for an SQL tutorial. It's not hard to learn this kind of thing

Good Luck

 

[rycamor]

Yes, MySQL can have temporary tables (please check documentation before giving answers).

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

CREATE TEMPORARY TABLE mytemptable (colunm stuff...);

This table will exist until your MySQL connection is dropped. Also, it's sometimes useful to create a temp table in memory, rather than on the disk, using the HEAP type:

CREATE TEMPORARY TABLE mytemptable (colunm stuff...etc...)TYPE=HEAP;

Since the table is only in RAM, queries will execute faster, and why use disk space if you aren't saving the table results?

Also see

http://www.mysql.com/doc/T/e/Temporary_table_problems.html

 

[K1BBQ]

well, I see there is a temp table in MySQL. Sorry, and thanks, rycamor, for the learning.