List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:September 1 2003 12:41am
Subject:Re: spaces in index name
View as plain text  
* 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
Thread
spaces in index nameBenjamin KRIEF1 Sep
  • Re: spaces in index nameRoger Baklund1 Sep
  • Re: spaces in index nameDan Nelson1 Sep
  • Re: spaces in index nameMatt W1 Sep
    • Re: spaces in index nameBenjamin KRIEF1 Sep
  • Re: spaces in index nameMatt W1 Sep