用表1 php mysqli更新表2的更好的方法是什么?
对于我来说,使用while循环和update row
<?PHP
session_start();
include("connect.php");
$query = "SELECT * FROM table_1";
$result = mysqli_query($db_mysqli, $query);
while($row = mysqli_fetch_assoc($result))
{
$id = $row['id'];
$money = $row['money'];
$db_mysqli->query("Update table_2 Set money = '$money' WHERE id = '$id'");
}
?>我想知道php有没有代码在1步内用表1更新表2?
发布于 2017-05-10 19:09:54
只需将查询更改为
Update table_2 Set money = (select money from table_1 where table_1.id = table_2.id)您的整个代码将是:
<?PHP
session_start();
include("connect.php");
$query = "Update table_2 Set money = (select money from table_1 where table_1.id = table_2.id)";
$db_mysqli->query($query);
?>https://stackoverflow.com/questions/43890690
复制相似问题