Hello the list,
I try to create a table with a TEXT primary key, and this error message
appear :
ERROR 1170 : BLOB column 'MY_COLUMN' used in key specification without a key
length.
What is the syntax to settle a key length ?
Here is my sql code to create my table:
--
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