phpmyadmin 修改表前缀

<?php
$host = 'localhost';
$user = 'root';
$password = '';
$dbname = 'your_database';

$conn = new mysqli($host, $user, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$old_prefix = 'old_';
$new_prefix = 'new_';

$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '$dbname' AND TABLE_NAME LIKE '$old_prefix%'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $table_name = $row['TABLE_NAME'];
        $new_table_name = str_replace($old_prefix, $new_prefix, $table_name);

        $alter_sql = "ALTER TABLE `$table_name` RENAME TO `$new_table_name`";
        if ($conn->query($alter_sql) === TRUE) {
            echo "Table $table_name renamed to $new_table_name\n";
        } else {
            echo "Error renaming table: " . $conn->error . "\n";
        }
    }
} else {
    echo "No tables found with prefix $old_prefix\n";
}

$conn->close();
?>