Code: Select all
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