'Mysql stored procedure that can take a list with an undefined number of items as input

I'm making an application with python that communicates directly with a MySql database over the internet through an user that has access only to stored procedures. When registering an invoice it can be related to 1, 2, 3 or many more items.

I want to register the invoice and which items it is related to with a single procedure for atomicity and prevent tables from being locked due to hanging transactions.

What is the proper way of dealing with this kind of situation?

mysqlstored-proceduresmysql-python


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions