How to performs multiple query on the database Oracle using PHP Language [duplicate]

Question

In order to run a query for database MySQL, we are using mysqli_query. Then, for running a query for database Oracle, we are using oci_execute.

When we wish to running multiple query for database MySQL, we are using mysqli_multi_query. Example as below:-

$mysqliconn = mysqliconn();         //mysqli connection
$sql = '
INSERT INTO TABLE VALUES();
INSERT INTO TABLE VALUES();
INSERT INTO TABLE VALUES();
INSERT INTO TABLE VALUES();
';
if(mysqli_multi_query($mysqliconn, $sql)) {
    echo 'Success';
}

My Question is if there anyone of you whom can come out with the most simplest solution to run multiple inserting values into the database table using one command execution.

There's a similar question here: stackoverflow.com/questions/2449132/… Would that help? — Hugo
– Hugo, Commented Sep 17, 2019 at 9:16
Mimi in MySQL the way you've shown us isn't the best way to insert multiple entries. You should rather use INSERT INTO table VALUES (), (), (); — Cid
– Cid, Commented Sep 17, 2019 at 9:21
By the way, if your question is about Oracle, don't tag other RDBMS — Cid
– Cid, Commented Sep 17, 2019 at 9:25
@Hugo, my question is for Oracle. I just give an example in MySQL. Anyway, thanks for answering. — Mimi
– Mimi, Commented Sep 18, 2019 at 2:36

Code Spirit · Accepted Answer · 2019-09-17 09:22:28Z

0

Oracle has an INSERT ALL statement for that. Otherwise you could just loop in your code and execute it n times.

answered Sep 17, 2019 at 9:22

Code Spirit

5,1776 gold badges30 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mimi Over a year ago

INSERT ALL statement is really works. Thank you for giving me a new knowledge.

Phi Cuong · Accepted Answer · 2019-09-17 09:23:14Z

-1

$sql = '
INSERT INTO TABLE abc VALUES(123,'xyz'),(456,'def'),(789,'qwe');
';

I suggest that using support library ^^

answered Sep 17, 2019 at 9:23

Phi Cuong

11 bronze badge

1 Comment

Cid Over a year ago

this doesn't work in Oracle

Collectives™ on Stack Overflow

How to performs multiple query on the database Oracle using PHP Language [duplicate]

2 Answers 2

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Linked

Related