multi query with prepared statement about mysql

[enumag]

What error?

[ori1989]

Fatal error: Uncaught Amp\Sql\QueryError: MySQL error (1064): #42000 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * from temp2 WHERE id = ?' at line 2 Current query was SELECT * from temp1 WHERE id = :id1; SELECT * from temp2 WHERE id = :id2;
...

Note: When I checked each of the prepared queries without the another one, it worked.
However, when I put these 2 prepared queries together, I got this error.

[kelunik]

I guess multiple queries in one statement aren't currently supported. I'd advise you to use separate prepared statements.

[fshahzad]

You can try the 'Union' or 'Union All' between two or more queries.

[trowski]

This is now supported in the v3 branch compatible with Amp v3 + PHP 8.1 + fibers.