sql key error

[lipun4u]

I have arequirement that a table has to contain 3 columns, user_id, url and name. I want to make the url primary key. Go throw the following sql query.

mysql> CREATE TABLE blog_details (
    -> user_id INT(11),
    -> blogname VARCHAR(1024),
    -> blogurl VARCHAR(1024) NOT NULL,
    -> PRIMARY KEY(blogurl),
    -> FOREIGN KEY (user_id) REFERENCES login(user_id)
    -> ON DELETE CASCADE
    -> );
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

How can I fix the above error ???

[Mchl]

Why do you think making url a primary key is a good idea at all?

[Daniel0]

VARCHAR fields also cannot be longer than 255.

[Mchl]

They can (up to 65536) since MySQL 5.0.3

[Daniel0]

Hmm... oh well. I supposed I should have read the fucking manual.

[lipun4u]

My version is...

 

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.1.32-community |
+------------------+
1 row in set (0.02 sec)

mysql>

 

If I remove the primary key and not null, everything is fine. What should I do ??

[Daniel0]

Use a numeric primary key, or make it shorter than 767 bytes.

[Mchl]

If you want urls to be unique, create UNIQUE index in this column (though this might be limited to 767 chars as well)

[Daniel0]

I don't think I've ever seen a URL that's a kilobyte long though, so you can safely decrease the size to something more realistic.

[lipun4u]

how much u suggest to keep the length ???