"Multiple statements detected in a single query" while executing multiple query in one go!

Help Query Tuning
,
1

Hi,

I am trying to run multiple queries in one go like following:

“ALTER TABLE table1 ADD column column1 LONGTEXT;ALTER TABLE table1 ADD column column2 DATETIME;ALTER TABLE table1 ADD column column3 DATE;ALTER TABLE table1 ADD column column4 BIGINT;ALTER TABLE table1 ADD column column5 DATETIME;ALTER TABLE table1 ADD column column6 DATETIME;”

It is throwing error as following:

{
........
  sqlMessage: 'Multiple statements detected in a single query. ALTER TABLE table1 ADD column column1 LONGTEXT'
}

Let me know if there is any mistake from my side or Singlestore doesn’t allow multiple queries to be executed in one go.

2

What app or client library are you running those statements from?

You can run more than one statement at once from the standard mysql (or singlestore) command line client. I tried your example and it ran fine for me with the singlestore command line.

3

Are you using DataGrip?
On the Data Sources tab under URL after your db name add
?allowMultiQueries=TRUE