Tag Info

New answers tagged

1

Try batching the deletes, so that you are only checking a small set of records at a time, and so are locking a smaller set of records. You can play around with increase or decreasing the size of @batchSize until you find the "magic number" that performs best for you. Note: I don't normally work in MySQL so my while loop syntax may not be 100% correct, but ...


0

This seems be an on-going bug although it is not considered a bug, such as Bug #73041: Error 1366 when loading null into columns with decimal type using strict mode According to Oracle's MySQL Documentation If you are not using strict mode, then whenever you insert an “incorrect” value into a column, such as a NULL into a NOT NULL column or a too-large ...



Top 50 recent answers are included