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
Y (id);
Hope that helps.
Matt
- Original Message -
From: "Benjamin KRIEF"
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
hi all ,
i'm trying to improve performance of a quite big and heavily used
mysql
set of tables.
i want to create some i
`,
-- Drop the PRIMARY KEY with 2 id columns
DROP PRIMARY KEY,
-- And re-add it with just one column
ADD PRIMARY KEY (id);
Hope that helps.
Matt
- Original Message -
From: "Benjamin KRIEF"
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
> hi all ,
>
> i&
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
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 sometimes
duplicate , and somtimes useless.
here is an output from s
