On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote:
>
> ---snip---
>
> mysql> alter table Headlines modify Url TINYTEXT NOT NULL;
>
> ERROR 1170: BLOB column 'Url' used in key specification without a key length
Oh, okay. Now I understand.
The max key length is 256, so I'd need to specify a number <= 256 in
the index for that column. Hmm.
It'd be really nice if the 256-character max key length wasn't a
compile-time directive, but a run-time directive instead.
Back to the drawing board a bit...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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