Hi, Yes ofcourse it is a primary key with two fields. The insert exists whenever it has a duplicate entry, it doesn't continue with further records. Is there any scope to resolve it.
Thanks Suresh Eldo Skaria wrote: > 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]
