Bulk Insert statements MYSQL Stored Procedure -
i have stored procedure need, amongst other things, able multiple inserts particular table. the number of inserts table can vary. the stored procedure being called via jdbc. passing parameters single insert statement stored procedure easy. there way can pass array of values stored procedure, , loop through array perform insert statements? i'm pretty new stored procedures, in advance help.... this achieved including in transaction , automatically rollback if goes haywire. done in jdbc setting connection autocommit false, , autocommiting conn.setautocommit(false); conn.commit();