标题:MYSQL 批量修改表前缀
出处:沧海一粟
时间:Wed, 14 Mar 2018 09:22:22 +0000
作者:jed
地址:http://www.dzhope.com/post/1091/
内容:
connect_error) die('Connect Error (' . $db->connect_errno . ') ' . $db->connect_error);
$query = $db->query('SHOW TABLES;');
$list = $query->fetch_all();
echo 'table : ', count($list),'
';
$len = strlen($old_pre);
foreach ($list as $val) {
$new_name = $new_pre.substr($val[0], $len, strlen($val[0])-$len);
echo "ALTER TABLE {$val[0]} RENAME {$new_name};
";
$db->query("ALTER TABLE {$val[0]} RENAME {$new_name};");
}
echo '
success.';
$db->close();
?>
Generated by Bo-blog 2.1.1 Release