List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:December 16 2000 3:31pm
Subject:Re: primary key...
View as plain text  
At 3:42 PM +0100 12/16/00, jed wrote:
>Hi  @,
>
>I have one table and one field in it is like primary key.
>So, if I would like to change the configuration of this table
>and just  to have a table without primary key....
>How can I make it?
>
>current configuration is:
>+-------+----------+------+-----+---------+----------------+
>| Field | Type     | Null | Key | Default | Extra          |
>+-------+----------+------+-----+---------+----------------+
>| f1    | int(11)  |      | PRI | 0       | auto_increment |
>| f2    | tinytext | YES  |     | NULL    |                |
>+-------+----------+------+-----+---------+----------------+
>
>
>I would like to say to mysql something like this:
>alter table test change column f1 f1 int
>but mysql says:
>Column 'f1' is used with UNIQUE or INDEX but is not defined as NOT NULL


Try:

alter table test drop primary key, change column f1 f1 int

-- 
Paul DuBois, paul@stripped
Thread
mysqldump: create syntax errorSMantscheff13 Dec
  • primary key...jed16 Dec
    • Re: primary key...Paul DuBois16 Dec
  • Re: primary key...jed16 Dec