Re: Disable/Enable Keys and Duplicate Records

2003-10-13 Thread Matt W
sage - From: "Randy Chrismon" Sent: Monday, October 13, 2003 9:48 AM Subject: Disable/Enable Keys and Duplicate Records I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table

Disable/Enable Keys and Duplicate Records

2003-10-13 Thread Randy Chrismon
I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table my_table disable keys. Import 200K records. Alter table my_table enable keys. But it turns out there are duplicate records. Does MySQL a