insert_batch() not working completely

That's expected.

Check the MySQL documentation, you can define columns only once.

Code:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

Thank you very much for commenting on my query. Hope, You have read my question. So this is not an answer of question.


insert_batch() should work with different keys. It works fine when keys will be same in the array.