作者:惜洛妍_311 | 来源:互联网 | 2018-03-22 20:42
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;
}
}