mysql 批量执行sql语句脚本

懒鸟一枚

于 2024-07-30 23:01:04 发布

阅读量57

点赞数 1

分类专栏：数据库 linux 文章标签： mysql sql 数据库

本文链接：https://blog.csdn.net/tian830937/article/details/140808870

版权

linux 同时被 2 个专栏收录

52 篇文章 1 订阅

订阅专栏

数据库

19 篇文章 1 订阅

订阅专栏

有时候我们需要批量执行多个数据库的创建和数据创建执行可以通过下面脚本批量创建和执行脚本。我们只需要在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 -ptest

CREATE 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;