add table prefixes
dereine — 27. Juli 2010 - 21:57
$old = '';
$new = 'blog_';
$result = db_query("SHOW TABLES");
while ($r = db_fetch_array($result)) {
$table_old = current($r);
$table_new = $new.str_replace('^'.$old, '', $table_old);
db_query("RENAME TABLE {$table_old} TO {$table_new}");
print "{$table_old} -> {$table_new}";
}
$new = 'blog_';
$result = db_query("SHOW TABLES");
while ($r = db_fetch_array($result)) {
$table_old = current($r);
$table_new = $new.str_replace('^'.$old, '', $table_old);
db_query("RENAME TABLE {$table_old} TO {$table_new}");
print "{$table_old} -> {$table_new}";
}
Kommentar hinzufügen