广州传奇网络
地址:广州市天河区东圃大马路富华楼C座
电话:13808825895
QQ:1564443073
$database = ‘target’;
mysql_connect(‘localhost’,'root’,”) or die(‘cannot connect’);
mysql_select_db($database);
$query = mysql_query(‘show tables’);
$prefix = ‘target’;
while($row = mysql_fetch_array($query)){
$tableName = $row['Tables_in_'.$database];
$string = explode(‘_’,$tableName);
if($string[0]!=$prefix){
$string[0] = $prefix;
$newTableName = implode(‘_’, $string);
mysql_query(‘rename table ‘.$tableName.’ TO ‘.$newTableName);
}
}