Codice PHP:
$query = mysql_query("show tables from tuo_db") or die (mysql_error() );
define('PREF','php_');
while ($riga = mysql_fetch_row($query)) {
$query2 = "alter table $riga[0] rename ".PREF."$riga[0]";
//echo $query2.'
';
mysql_query($query2) or die(mysql_error() );
}