使用PDO将MySQL表行移动到另一个表

$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "username";
$password = "password";

try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
    exit;
}

$sql = "SELECT * FROM table1 WHERE condition";
$stmt = $pdo->query($sql);

$pdo->beginTransaction();

$targetTable = "table2";
$insertSql = "INSERT INTO $targetTable (column1, column2, ...) VALUES (:value1, :value2, ...)";
$insertStmt = $pdo->prepare($insertSql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // 绑定参数
    $insertStmt->bindValue(':value1', $row['column1']);
    $insertStmt->bindValue(':value2', $row['column2']);
    // ...
    
    // 执行插入操作
    $insertStmt->execute();
}

$pdo->commit();
$pdo = null;