Re: Dropping primary key/unique key

2003-08-14 Thread Sergei Golubchik
Hi! On Aug 07, Nils Valentin wrote: > [Warning: LNG TEXT - enjoy ;-)] > > Hi Victoria, > > sorry for the misunderstanding. I just tried to reproduce the sample. While I > have records what I did I did not write down all commands exactly as they > are. > > The problem(s) occured on Redhat

Re: Dropping primary key/unique key

2003-08-14 Thread Nils Valentin
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 i

Re: Dropping primary key/unique key

2003-08-14 Thread Nils Valentin
[Warning: LNG TEXT - enjoy ;-)] Hi Victoria, sorry for the misunderstanding. I just tried to reproduce the sample. While I have records what I did I did not write down all commands exactly as they are. The problem(s) occured on Redhat 8 or 9 and Mysql server-max 4.0.13 (tar format) from

Re: Dropping primary key/unique key

2003-08-14 Thread Victoria Reznichenko
"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 d

Re: Dropping primary key/unique key

2003-08-11 Thread Victoria Reznichenko
"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 th

Re: Dropping primary key/unique key

2003-08-07 Thread Nils Valentin
Update: 2003年 8月 7日 木曜日 17:06、Nils Valentin さんは書きました: > [Warning: LNG TEXT - enjoy ;-)] > > Hi Victoria, > > sorry for the misunderstanding. I just tried to reproduce the sample. While > I have records what I did I did not write down all commands exactly as they > are. > > The problem(s) occur

Re: Dropping primary key/unique key

2003-08-06 Thread Cybot
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; +---+---