Execute multiple statements (operation) at same time in MySQL

on Apr 27, 2021 11:41 PM

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).

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

thank you for advance.

Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Apr 27, 2021 11:49 PM

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;