利用mysql客户端批量执行sql语句

最新推荐文章于 2024-07-30 23:01:04 发布

maray

最新推荐文章于 2024-07-30 23:01:04 发布

阅读量6.3k

点赞数

分类专栏：编程与应用

本文链接：https://blog.csdn.net/maray/article/details/8472142

版权

编程与应用专栏收录该内容

233 篇文章 2 订阅

订阅专栏

[xiaochu.yh@OceanBase ~]$ cat my.sql 
create table x (a1 int, a2 int, a3 int, b1 int, b2 int, primary key(a1,a2,a3));
insert into x(a1,a2,a3,b1,b2) values (1,1,2,0,0);

[xiaochu.yh@OceanBase ~]$ mysql -h1.32.36.29 -P4797 -uadmin -padmin < my.sql 
[xiaochu.yh@OceanBase ~]$ mysql -h1.32.36.29 -P4797 -uadmin -padmin
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 0
Server version: 5.5.1 OceanBase 0.4.1 (r11236) (Built Jan 5 2013 16:08:48)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from x;
+------+------+------+------+------+
| a1 | a2 | a3 | b1 | b2 |
+------+------+------+------+------+
| 1 | 1 | 2 | 0 | 0 |
+------+------+------+------+------+
1 row in set (0.00 sec)

在OceanBase中，将sql语句写到my.sql文本文件中，然后用重定向命令将其批量导入到mysql客户端中执行即可。