php添加和合并来自两个表的数据

<?php
// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 编写SQL查询语句
$sql = "SELECT * FROM tableA";
$resultA = $conn->query($sql);

$sql = "SELECT * FROM tableB";
$resultB = $conn->query($sql);

// 处理结果集
if ($resultA->num_rows > 0 && $resultB->num_rows > 0) {
    // 遍历结果集A，将数据插入到目标表
    while ($rowA = $resultA->fetch_assoc()) {
        $dataA = $rowA['columnA']; // 假设表A的列名为columnA
        // 使用INSERT语句将数据插入到目标表
        $sql = "INSERT INTO targetTable (column) VALUES ('$dataA')";
        $conn->query($sql);
    }

    // 遍历结果集B，将数据插入到目标表
    while ($rowB = $resultB->fetch_assoc()) {
        $dataB = $rowB['columnB']; // 假设表B的列名为columnB
        // 使用INSERT语句将数据插入到目标表
        $sql = "INSERT INTO targetTable (column) VALUES ('$dataB')";
        $conn->query($sql);
    }

    echo "数据添加和合并成功！";
} else {
    echo "没有找到需要的数据。";
}

// 关闭数据库连接
$conn->close();
?>