php - SQL PHP 插入表

Question

是否可以为此插入多个表？

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

如何加入表格:

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;
}

Answer 1

MySQL不支持通过单个插入语句插入多个表，我相信Oracle只支持它。

但是您可以使用事务来确保所有插入语句都通过单个事务执行。