I have the following index:
CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so,
how can I have it so that it is indeed case sensitive because
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
Thanks.
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Case sensitive indexes
Date: Tue, 26 Aug 2003 13:18:19 +0300
gord barq [EMAIL PROTECTED] wrote:
I
Hi,
I'm importing ~2000 rows using mysqlimport with the following syntax:
mysqlimport -d -v --ignore -u root -p[rootpw] [database] [tablename].txt
Connecting to localhost
Selecting database [database]
Deleting the old data from table [tablename]
Loading data from SERVER file:
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER JOIN
searchresult ON
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select count(count(*)) from results group