"Nils Valentin" <[EMAIL PROTECTED]> wrote: > Hi Victoria, > > Victoria Reznichenko wrote: > >>"Nils Valentin" <[EMAIL PROTECTED]> wrote: >> >> >>>I have a problem understanding why MySQL is deleting a unique key instead of >>>a primary key. >>> >>>from Documentation: DROP PRIMARY KEY drops the primary index. If no such index >>>exists, it drops the first UNIQUE index in the table. >>> >>>When I do it then I get this: >>> >>>mysql> desc uksample4; >>>+-------+----------+------+-----+---------+-------+ >>>| Field | Type | Null | Key | Default | Extra | >>>+-------+----------+------+-----+---------+-------+ >>>| id | int(11) | | UNI | 0 | | >>>| name | char(30) | YES | | NULL | | >>>| tel | char(20) | | PRI | | | >>>+-------+----------+------+-----+---------+-------+ >>>3 rows in set (0.00 sec) >>> >>>mysql> alter table uksample4 drop primary key ; >>>Query OK, 0 rows affected (0.24 sec) >>>Records: 0 Duplicates: 0 Warnings: 0 >>> >>>mysql> desc uksample4; >>>+-------+----------+------+-----+---------+-------+ >>>| Field | Type | Null | Key | Default | Extra | >>>+-------+----------+------+-----+---------+-------+ >>>| id | int(11) | | | 0 | | >>>| name | char(30) | YES | | NULL | | >>>| tel | char(20) | | PRI | | | >>>+-------+----------+------+-----+---------+-------+ >>>3 rows in set (0.00 sec) >>> >>>It deletes the unique key (id) instead of he primary key (tel). >>> >>>Did I do something wrong ? >>> >>>MySQL 4.0.14 >>> >>> >> >>Your example worked fine for me. Could you provide a test case? >> >> > I know that the example worked as decribed above, thank you for > confirming it. :-) > My Question is, why would it not drop the primary key, but the unique > key instead ?? > > Which command would delete the primary key ?
MySQL drops primary key for me. That is why I ask you about test case. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
