From: Adam Hardy (adam.sqlcyberspaceroad.org)
Date: Mon Feb 02 2004 - 16:15:27 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I've got to create a table that has the following:

CREATE TABLE access (
   query VARCHAR(255) NOT NULL,
   INDEX (query)
);

and mysql is telling that the max bytes allowed is 500 for key length.
The docs say I can change this by recompiling, which I would like to
avoid having to do. Is there any way around this to get a 255 character
length field with index?

This is going to store weblog entries, so it's going to be a huge table.
Is there a different table type / column type / index type I could use
to achieve what I need?

thanks in advance
Adam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]