I am trying to create an index with multiple fields.
The sixe of each of the column is listed and thier sum is 560bytes. But when I
try to create an index with the colums, it complains on the size exceeded 1024
bytes. Below is the query and the size of each..
create index selectTechnologyClubsThread_idx on content
(club_id, date_update, subject, message_id, id, date_published,
comment_count_d, display_usr_name_d, short_content)
COLUMN_NAME TYPE SIZE
club_id Bigint 8
date_update Bigint 8
Subject Varchar(120) 121
message_id varchar(120) 121
Id Bigint 8
date_published Datetime 8
comment_count_d Int 4
short_content Varchar(250) 251
display_usr_name_d Varchar(30) 31
TOTAL : 560
Any sort of help would be great....
- javabuddy
----------------------------------------------------------------------------------------------------
People are conversing... without posting their email or filling up their mail
box. ~~1123867827435~~
roomity.com http://roomity.com/launch.jsp No sign up to read or search this
Rich Internet App
----------------------------------------------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
