-
-
$database = "databaseName"; //Database name - $user = "root"; //Database user name
- $pwd = "pwd"; //Database Password
- $replace ='pre_';//Prefix after replacement
- $seach = 'pre1_';//Prefix to be replaced
- $db=mysql_connect("localhost","$user","$pwd") or die("Failed to connect to database:".mysql_error()); //Connect to database
$tables = mysql_list_tables("$database"); - while($name = mysql_fetch_array($tables) ) {
$table = str_replace($seach,$replace,$name['0']); mysql_query("rename table $name[ 0] to $table"); - }
- // bbs.it-home.org
- ?>
-
If you add a prefix, you can make the following modifications:
$table = str_replace($seach,$replace,$name['0']);
change into:
$table = $replace.$name['0'];
| 
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
