Adam Hardy <[EMAIL PROTECTED]> wrote: > 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?
Your CREATE TABLE statement worked like charm for me. What version of MySQL server do you use? > 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? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
