I'm trying to run a few complex queries in order to render a single output using DB Connect.
I cannot seem to get them all to run together on one line as if I were at the mysql console.
Query Example (won't go into detail, just the basic structure):
DROP....DROP....DROP....SELECT ... FROM ... WHERE... GROUP...;
CREATE TEMPORARY TABLE.....;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
CREATE TEMPORARY TABLE.....;
DROP TABLE...;
DROP TABLE...;
SELECT....;
So we have 9 statements here, the total number and the structure of each doesn't really matter because they work just fine individually, just not together as one big query. They produce the desired output in the mysql console and through several other methods.
Can Splunk DB Connect execute multiple queries as one?
... View more