I want to know If we can execute multiple queries at the same time in MYSQL/SQL. Let me explain a case scenario to elaborate my statement further.
Let's Assume, We have to create and load two tables.create table tbl1(col,col,col,col...); Insert Into tbl1 (val,val,val,val...) and other query as create table tbl2(col,col,col,col...); Insert Into tbl2 (val,val,val,val...). Now, When I execute the statement the flow will be
- Create Table1
- Insert Into Table1
- Create Table2
- Insert Into Table2
Is there any method We can use to minimize these 4 steps into a single step? Similar to the functionality of threads that run in parrallel.
