>ERROR 1170 : BLOB column 'MY COLUMN' used in key specification without a key >length. What is the syntax to settle a key length ?
ALTER TABLE your_table add key blob_field (blob_field(50)); Or, you can create a table like this one: CREATE TABLE `your_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(2) NOT NULL default '', `blob_field` TEXT, PRIMARY KEY (`id`), KEY `blob_field` (`blob_field`(20)) # indexed on the first 20 characters of the field ) TYPE=MyISAM BLOB and TEXT field can be indexed on a fixed amount of data only. Therefore you must specify the length of the index. Giuseppe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
