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

Zar · Accepted Answer · 2013-01-29 14:51:24Z

5

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()

edited Jan 29, 2013 at 14:51

Zar

6,93210 gold badges56 silver badges76 bronze badges

answered Nov 16, 2011 at 18:38

John Cartwright

5,07424 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kumar Over a year ago

CI doesn't let you override db class :(

John Cartwright Over a year ago

Which db client is it using? Mysql? Mysqli? If it truly not flexible enough and you are stuck with a client that does not support multiple queries, then you are simply left with having to execute each query individually.

Kumar Over a year ago

Thanks a ton John! This is how I fixed it mysqli_multi_query($this->db->conn_id, $sql); where $sql has batch SQL commands. Apart from this unseen issue I just had to build MDBTools from source. Thanks!

Collectives™ on Stack Overflow

Codeigniter - how to run multiple/batch queries?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related