INSERT IGNORE in MySQL 4.1 - purpose?
Posted: Fri Jun 22, 2007 5:43 pm
After staring at the screen for what feels like hours, I think I've realized the purpose of INSERT IGNORE, which appears to be precisely the opposite of what I thought. Could someone confirm this?
I *thought* INSERT IGNORE would ignore the fact that my table already contains a record with unique key and INSERT the new record right over top of it. It appears that what it REALLY does is ignore the new row, insert nothing, and not give me the duplicate key error I would get if I didn't use IGNORE.
Am I right?
I *thought* INSERT IGNORE would ignore the fact that my table already contains a record with unique key and INSERT the new record right over top of it. It appears that what it REALLY does is ignore the new row, insert nothing, and not give me the duplicate key error I would get if I didn't use IGNORE.
Am I right?