高境网站建设,海南网站策划,网上网站建设教程,网站建设faq系统指什么有时候我们需要批量执行多个数据库的创建和数据创建执行可以通过下面脚本批量创建和执行脚本。我们只需要在sql命令行或者客户端执行下面一个脚本批量创建执行多个库的创建和执行
xxxxinit.sql
create user root% identified by test;
mysql -h 192.168.17.7 -u root -p
mysq…有时候我们需要批量执行多个数据库的创建和数据创建执行可以通过下面脚本批量创建和执行脚本。我们只需要在sql命令行或者客户端执行下面一个脚本批量创建执行多个库的创建和执行
xxxxinit.sql
create user root% identified by test;
mysql -h 192.168.17.7 -u root -p
mysql -h 127.0.0.1 -u root -ptestCREATE DATABASE mock_bizcenter CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_plan CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_xpom CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_compoment_assignment CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_flow CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE tasks_manager_app CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE usercomponent CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_base_adapter CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_base_filenode CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_contract CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_document CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_knowledge CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_process CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_project CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_quality CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_biz_sqcdp CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE mock_compoment_procintelligence CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE v-page CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;tee F:/comac/mock_bizcenter.output;
use mock_bizcenter;
source F:/comac/mysql/mock_bizcenter.sql;
tee F:/comac/mock_compoment_assignment.output;
use mock_compoment_assignment;
source F:/comac/mysql/mock_compoment_assignment.sql;
tee F:/comac/tasks_manager_app.output;
use tasks_manager_app;
source F:/comac/mysql/tasks_manager_app.sql;
tee F:/comac/usercomponent.output;
use usercomponent;
source F:/comac/mysql/usercomponent.sql;
tee F:/comac/mock_base_adapter.output;
use mock_base_adapter;
source F:/comac/mysql/mock_base_adapter.sql;
tee F:/comac/mock_base_filenode.output;
use mock_base_filenode;
source F:/comac/mysql/mock_base_filenode.sql;
tee F:/comac/mock_biz_contract.output;
use mock_biz_contract;
source F:/comac/mysql/mock_biz_contract.sql;
tee F:/comac/mock_biz_document.output;
use mock_biz_document;
source F:/comac/mysql/mock_biz_document.sql;
tee F:/comac/mock_biz_knowledge.output;
use mock_biz_knowledge;
source F:/comac/mysql/mock_biz_knowledge.sql;
tee F:/comac/mock_biz_process.output;
use mock_biz_process;
source F:/comac/mysql/mock_biz_process.sql;
tee F:/comac/mock_biz_project.output;
use mock_biz_project;
source F:/comac/mysql/mock_biz_project.sql;
tee F:/comac/mock_biz_quality.output;
use mock_biz_quality;
source F:/comac/mysql/mock_biz_quality.sql;
tee F:/comac/mock_biz_sqcdp.output;
use mock_biz_sqcdp;
source F:/comac/mysql/mock_biz_sqcdp.sql;
tee F:/comac/mock_compoment_procintelligence.output;
use mock_compoment_procintelligence;
source F:/comac/mysql/mock_compoment_procintelligence.sql;
tee F:/comac/mock_biz_plan.output;
use mock_biz_plan;
source F:/comac/mysql/mock_biz_plan.sql;
tee F:/comac/mock_biz_xpom.output;
use mock_biz_xpom;
source F:/comac/mysql/mock_biz_xpom.sql;
tee F:/comac/mock_flow.output;
use mock_flow;
source F:/comac/mysql/mock_flow.sql;
tee F:/comac/v-page.output;
use v-page;
source F:/comac/mysql/v-page.sql;
