1. [php]代码 $setting = array(
'databasehost' => '127.0.0.1',
'databaseuser' => 'root',
'databasepass' => '',
'olddatabasename' => 'old_database_name',
'newdatabasename' => 'new_database_name',
'execute' => false,
);
$db = new pdo("mysql:host={$setting['databasehost']};dbname={$setting['olddatabasename']}", $setting['databaseuser'], $setting['databasepass']);
$result = $db->query("show tables");
$tables = $result->fetchall();
foreach ($tables as $tablectr) {
$tablename = $tablectr['tables_in_' . $setting['newdatabasename']];
$sql = "alter table $tablename rename to " . str_replace('mymps', 'mk_', $tablename);
$sql = "rename table {$setting['olddatabasename']}.{$tablename} to {$setting['newdatabasename']}.{$tablename};";
if ($setting['execute']) {
if ($db->query($sql)) {
continue;
} else {
exit($db->errorinfo());
}
} else {
echo $sql . php_eol;
}
}