$this->EE->db->query(); is it possible to execute a query as complicated as this:
CREATE TEMPORARY TABLE exp_temp_table (...); INSERT INTO exp_temp_table () SELECT ...; UPDATE exp_temp_table ... SET ...; SELECT ... FROM exp_temp_table ...;
For obvious reasons I've removed most of the actual statements.
This code executes perfectly in phpMyAdmin, but when I try to use
$this->EE->db->query(); I get a SQL error at
INSERT INTO exp_temp_table ()... - is it not possible to execute queries with multiple statements? If not, is there some way I can work around this?