SQL request?

[naceur]

I want to use this request "select count(distinct Name_Champ) from Name_table into temp Name_temprory_table;"
in MySql.
but the response of the MySql is:
"MySQL a répondu:You have an error in your SQL syntax near 'Name_temprory_table from Name_table ' at line 1"
thanks

 

[Cagliostro]

what does 'distinct' inside of count mean? John Fill

ivfmd@mail.md

 

[naceur]

This request "select count(distinct Name_Champ) from Name_table into temp Name_temprory_table;" mean's :
Select the count of all distinct Name_Champ and insert it in temporary table named Name_temprory_table.
thinks.

 

[Cagliostro]

As I know, it means nothing.
Correct is:
select distinct count(Name_... John Fill

ivfmd@mail.md