I have a bunch of requests that are generated by a shell script on one server and should be consumed by a CI application on another server. Requests are executed normally when they are launched individually, but do not work when launched as a package. Is there a way out? Please note that these are not multiple inserts or updates, and queries can span more than one row.
This is not a limitation of CodeIgniter, but rather client database libraries.
Ie, mysql_query() can only execute one query at a time.
mysql_query()
There are alternatives, depending on the client,
Ie, mysqli_multi_query()
mysqli_multi_query()