php怎么修改表数据库名 php数据库修改语句

mysql 数据库的复制或是备份。在复制或备份过程中实现修改数据库名和数据库中的表名？

如果my库中只有少量php怎么修改表数据库名的表php怎么修改表数据库名，那wallcopper 提供的方案是可行的php怎么修改表数据库名，如果是my中的表很多，比如说100个表，那就要操作100次，比较麻烦；

我这边有个方案，php怎么修改表数据库名你可以试试，前提是php怎么修改表数据库名你该表名的规则必须一致，就比如说统一在表名后面加123，这样是可以的；

mysql -u root -p密码 --execute="select concat('create table ','wangxh123.',table_name,'123 as select * from wangxh.',table_name,';') from information_schema.tables where table_schema='wangxh'"d:\\test.sql

-------------------------------------------------------

上面的命令是直接在cmd下执行，作用是生成复制表的语句：

concat('create table ','wangxh123.',table_name,'123 as select * from wangxh.',table_name,';')

create table wangxh123.iptest123 as select * from wangxh.iptest;

create table wangxh123.jj123 as select * from wangxh.jj;

create table wangxh123.test123 as select * from wangxh.test;

create table wangxh123.test1123 as select * from wangxh.test1;

create table wangxh123.test_index123 as select * from wangxh.test_index;

create table wangxh123.testinnodb123 as select * from wangxh.testinnodb;

create table wangxh123.testtype123 as select * from wangxh.testtype;

create table wangxh123.testuid123 as select * from wangxh.testuid;

create table wangxh123.time_test123 as select * from wangxh.time_test;

create table wangxh123.time_test2123 as select * from wangxh.time_test2;

create table wangxh123.tmpip123 as select * from wangxh.tmpip;

create table wangxh123.wangxh123 as select * from wangxh.wangxh;

-----------------------------------------------------------------------

文件内容的第一行不要复制，复制其他几行然后在mysql命令行执行就可以，他会把wangxh库里的表复制到wangxh123库，并在新表名后面加上123 注意，wangxh123库需要你自己手工建一下

php怎么修改表数据库名的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于php数据库修改语句、php怎么修改表数据库名的信息别忘了在本站进行查找喔。