Re: spaces in index name

[Roger Baklund]

* Benjamin KRIEF 
[...]
> first of all , i'm asking myself : why is there 2 primary keys on the 
> same column ?

Don't know... strange.

[...]
> mysql> drop index login connexion on v2easy0_users;   
> ERROR 1064: You have an error in your SQL syntax near 'connexion on 
> v2easy0_users' at line 1
> 
> (the same goes with ' and " around the index name)

You can use backticks: 

drop index `login connexion` on v2easy0_users;

<URL: http://www.mysql.com/doc/en/Legal_names.html >

--
Roger