Hi,
- Original Message -
From: "Benjamin KRIEF"
Sent: Sunday, August 31, 2003 8:17 PM
Subject: Re: spaces in index name
> thanks for all your answers ! i'd never imagine that mailing-list to
be
> so active and efficient!
It's usually not that active on weeken
thanks for all your answers ! i'd never imagine that mailing-list to be
so active and efficient!
matt : does mysql locks the table during the whole alter table execution?
Matt W wrote:
Hi Ben,
When using column/index names with odd characters (such as spaces), you
need to use backticks (SHIFT
Hi Ben,
When using column/index names with odd characters (such as spaces), you
need to use backticks (SHIFT + the ~ key) around the name: `index id`
This ALTER TABLE query should make all the changes you want:
ALTER TABLE v2easy0_users
DROP INDEX `login connexion`,
DROP INDEX `index id`,
-- Dro
In the last episode (Sep 01), Benjamin KRIEF said:
> hi all ,
>
> i'm trying to improve performance of a quite big and heavily used mysql
> set of tables.
> i want to create some indexes on this table , but before this , i'd like
> to remove the ones created by my predecessor , which are sometim
* 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
