php - Codeigniter - how to run multiple/batch queries?

Question

I have a bunch of queries that are generated by a shell script on one server and are to be consumed by a CI app on another server. The queries run fine when run individually but fail when run as a batch. Is there any way out? Please note that these are not multiple inserts or updates and queries may span more than one line

Answer 1

This is not a limitation of CodeIgniter but rather of the database client libraries.

I.e., mysql_query() can only execute a single query at a time.

Depending on the client, there are alternatives,

I.e., mysqli_multi_query()