Hi, Suresh may be expressing that he has a primary key with two fields.
Eldo. On Tue, 21 Sep 2004 19:32:17 -0400, Rhino <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "Suresh" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, September 21, 2004 6:43 PM > Subject: Duplicate Entries > > > Hello All, > > > > I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a > > table with two primary key, my older mysql server insert all the records > > except the duplicate fields(Primary Key). Whereas in the new mysql > > server it exits whenever it sees a duplicate entry. How to resolve it ? > > > Am I understanding you correctly? It *sounds* like you're saying that you > have a table with TWO primary keys. As far as I know, it is not possible to > have two separate primary keys in a single table under any circumstances. Do > you mean that you have a single primary key that has two columns in it? > > Rhino > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Thanks & Regards, Eldo Skaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]