$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);
}
}
前提是表名有前缀 并以 ‘_’ 间隔 其他的试情况而定