Mysql batch replace database tables

: This article describes how to replace database tables in batches in mysql. For more information about PHP tutorials, see.

  Tables_in_jiameiyake;} // print_r ($ data); // table prefix foreach ($ data as $ k => $ v) {$ preg = preg_match ("/^ ($ old_prefix {1}) ([a-zA-Z0-9 _-] +)/I", $ v, $ v1); if ($ preg) {$ tab_name [$ k] = $ v1 [2] ;}// print_r ($ tab_name); if ($ preg) {// replace the table prefix foreach ($ tab_name as $ key => $ value) {$ SQL = "rename table ". $ old_prefix. $ value. "". $ new_prefix. $ value; echo $ SQL."
"; $ A = mysql_query ($ SQL); if ($ a) {print" data table :". $ old_prefix. $ value. "changed :". $ new_prefix. $ value ;}}}

                                                
The above section describes how to replace database tables in mysql in batches, including some content. I hope my friends who are interested in the PHP Tutorial will be helpful.