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
