----- 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]