I have setup my mysql catalog in my Trino engine. I am unable to query multiple queries put together in it.
For example, I want to execute below queries one by one sequentially in Trino.
<code>update <table_name> set <row_name> = 1;
drop <table_name2>;
select * from <table_name>;
</code>
<code>update <table_name> set <row_name> = 1;
drop <table_name2>;
select * from <table_name>;
</code>
update <table_name> set <row_name> = 1;
drop <table_name2>;
select * from <table_name>;
It says the query syntax is erroneous. I tried to find the correct way to query multiple queries at once in its documentation, but I couldn’t find any. Does Trino actually supports this? Could you assist on this?
Many thanks in advance.