Execute multiple statements (operation) at same time in MySQL

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;