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 abort the enable key? Does it drop one of the offending records? If so, which one? MySQL apparently does not have table where offending rows -- the ones deleted -- are stored? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
