Combining multiple requests into one, an error in one request interrupts others. How to let all requests work?

Question

MySQL

INSERT INTO `idAll`(`id`) VALUES ("awiSmp0XmYE"); // Вызывает ошибку так как значение дублируется в базе.
INSERT INTO `idAll`(`id`) VALUES ("WWWWW"); // Будет не выполнена, так как запрос выше вызвал ошибку

Answer 1

There is INSERT IGNORE (so-so solution, because it will ignore all errors).
There is an INSERT ... ON DUPLICATE KEY UPDATE that can be adapted .
If queries are made through the mysql client, there is a -f switch .