No, please don't go back into any corner. Discuss, please!
Are you a huge fan of the IGNORE keyword?
-jay
I personally (and my company) use the crap out of it. Along with LOAD DATA
INFILE that was previously discussed. If one or the other goes away, do we
have alternatives?
Think I've used INSERT IGNORE INTO ... SELECT FROM ... a bunch to collapse
data. There isn't really a way to handle bailouts in the middle, nor is it
always reasonable to adjust all of the data first. ie; You want the
constraint on one table but not another, for different views of the data.
We could potentially get by without using INSERT IGNORE in mogilefs by
handling and ignoring the errors... but bulk requeue attempts would bail
out in the middle, so we'd have to only do one at a time, which is slow.
-Dormando
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
