There's nothing like a batch here lol..
Right click on the mysql table (in navicat) then choose Console.
But in your code it seems the insert doesn't match your columns.
Track / follow the columns within' your code and delete/add the missing ones ,so it could match.