SQL PHP INSERT INTO tables

Question

Is it possible to INSERT INTO multiple tables for this?

SELECT first_name, last_name, feet, inche, weight, dob, college, pob, experience, cy, py
FROM player 
INNER JOIN attribute ON player.pid = attribute.pid
INNER JOIN history ON player.pid = history.pid
INNER JOIN salary ON player.pid = salary.pid

How do I join the tables for:

if(!($stmt = $mysqli->prepare("INSERT INTO player(first_name, last_name) VALUES (?, ?)"))){
   echo "Prepare for player failed: "  . $stmt->errno . " " . $stmt->error;
}
if(!($stmt->bind_param("ss", $_POST['first_name'],$_POST['last_name']))){
    echo "Bind failed: "  . $stmt->errno . " " . $stmt->error;
}

MySQL doesn't support multi-table insertion in a single INSERT statement — Ranjith
– Ranjith, Commented Jun 4, 2014 at 5:18
INSERT can happen only in one table at a time. You have to write multiple insert statement for inserting into more than one table. — prava
– prava, Commented Jun 4, 2014 at 5:18
Put a ; between insert statements, then it's kind of like one? — Andrew
– Andrew, Commented Jun 4, 2014 at 5:20
first your select is wrong! and secondly for inserting multiple entries you need to make an array and then pull it in one loop — SagarPPanchal
– SagarPPanchal, Commented Jun 4, 2014 at 5:28

Mayank K. Swami · Accepted Answer · 2014-06-04 05:28:03Z

1

MySQL doesn’t support insert into multiple tables via single insert statement, I believe Oracle is only support it.

But you can use a Transaction to make sure all insert statements execute via single transaction.

edited Jun 4, 2014 at 5:28

Mayank K. Swami

57.3k23 gold badges130 silver badges148 bronze badges

answered Jun 4, 2014 at 5:24

Suresh

1,1691 gold badge16 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

SQL PHP INSERT INTO tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related