On 26-Oct-2001 Tim Evans wrote:
> I have inherited a database built by someone else who was apparently
> very
> stingy. :-)
>
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
>
> I've tried:
>
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
>
> ...but got:
>
> ERROR 1121: Column 'phyid' is used with UNIQUE or INDEX but is not
> defined as NOT NULL
>
wait for it ...
alter table my_data modify phyid mediumint unsigned NOT NULL DEFAULT "0";
you may now bang your head on the wall.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
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
