Is there a way to catch more than one SELECT sentence in the same resultset?

Question

Hello, I'm learning about triggers a stored procedures in MySQL and I tried to do a stored procedure that run more than one query. Is it possible to handle them that way in java?

Answer 1

If the queries are related to each other, you can either use sub queries or JOIN your tables, perhaps UNION in some cases.
If you wanna handle the queries in Java, it really depends on what you wanna do with them... Either handle this them sequentially or run them in different threads for them to run in parallel to each other which is a bit harder to handle