PHP modify data table prefix

将 $old_prefix 和 $new_prefix Replace the prefix with the one you need, then save the code as a PHP file and execute it. Note that executing this operation may take some time, depending on the size of your database.

Absolutely perfect!

Here is a function.

/**
 * 修改 MySQL 数据库中数据表的前缀
 *
 * @param string $old_prefix 旧前缀
 * @param string $new_prefix 新前缀
 * @param string $db_host 数据库主机名
 * @param string $db_user 数据库用户名
 * @param string $db_password 数据库密码
 * @param string $db_name 数据库名
 *
 * @return bool 操作是否成功
 */
function changeTablePrefix($old_prefix, $new_prefix, $db_host, $db_user, $db_password, $db_name) {
    // 创建 MySQL 数据库连接
    $conn = new mysqli($db_host, $db_user, $db_password, $db_name);

    // 检查连接是否成功
    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    }

    // 获取所有数据表名
    $result = $conn->query("SHOW TABLES");

    // 遍历数据表名
    while ($row = $result->fetch_assoc()) {
        // 获取当前数据表名
        $table_name = $row['Tables_in_' . $db_name];

        // 如果数据表名以旧前缀开头，那么修改该数据表名
        if (strpos($table_name, $old_prefix) === 0) {
            $new_table_name = $new_prefix . substr($table_name, strlen($old_prefix));
            $conn->query("RENAME TABLE $table_name TO $new_table_name");
        }
    }

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

    // 返回操作结果
    return true;
}

This function accepts six parameters; the first two parameters old_prefix 和 new_prefix The first two parameters represent the old prefix and the new prefix to be replaced, respectively; the remaining four parameters are optional. db_host、db_user、db_password 和 db_name These represent the host name, username, password, and database name of the MySQL database, respectively. The function returns a boolean value indicating whether the operation was successful.

Within the function, first create a MySQL database connection, then use it. SHOW TABLES The command retrieves all table names from the current database and iterates over these table names. For each table name, the function checks whether it begins with the old prefix; if so, it uses it. RENAME TABLE The command replaces the name of the data table with the new prefix concatenated to the portion of the original prefix that remains after the new prefix. Finally, the function closes the MySQL database connection and returns the result of the operation.

Please note that modifying the prefix of a data table is a destructive operation; therefore, before running this function, be sure to back up your database and carefully verify the prefix you intend to modify to ensure that you are not altering any data tables that do not require modification.