RE: Using ALTER to modify type of a Primary Key; URGENT

2001-10-26 Thread Don Read 


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

Re: Using ALTER to modify type of a Primary Key; URGENT

2001-10-26 Thread Aleksandar Bradaric 

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