Hi,
> 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";
> ERROR 1121: Column 'phyid' is used with UNIQUE or INDEX but is not
> defined as NOT NULL
Try:
alter table my_data modify phyid mediumint unsigned NOT NULL DEFAULT "0";
--------
Sasa
---------------------------------------------------------------------
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
