Execute multiple statements (operation) at same time in MySQL

Last Reply 14 days ago By dharmendr

Posted 14 days ago

it is necessary to check whether multiple operation on a table take place in the same time.ex 20 query at time execute in one table

eg.test db-> in test db -> temparary table->in this table  i want multple operation insert ,update at same time (in timer )in c# window application .

i don't know any idea please tell me how to possible .

thank you for advance

You are viewing reply posted by: dharmendr 14 days ago.
Posted 14 days ago

Hi supriyan,

To execute multiple queries at a time use Semicolon (;) after each statement.

Refer below sample query and implement in your code.

INSERT INTO table1 (field1,field2) VALUES(1,2);
INSERT INTO table1 (field3,field4,field5) VALUES(3,4,5);
INSERT INTO table1 (field1,field2,field3,field4,field5) VALUES(6,7,8,9,10);
DELETE FROM table1 WHERE field5 = 10;
UPDATE table1 SET field2 = 10 WHERE field1 = 1;
SELECT * FROM table1;