Linux命令行执行MYSQL语句

最新推荐文章于 2024-06-23 15:31:06 发布

tiberx

最新推荐文章于 2024-06-23 15:31:06 发布

阅读量1.2k

点赞数

分类专栏： Linux运维

Linux运维专栏收录该内容

63 篇文章 0 订阅

订阅专栏

[root@localhost ~]# /usr/bin/mysql -N -e "show databases;use centreon2;select count(*) from host;source /home/centreon2.sql" 
+--------------------+
| information_schema | 
|          centreon2 | 
|  centreon2_storage | 
|              mysql | 
|             nagios | 
|               test | 
+--------------------+
+------+
| 1899 |

今天试验了非常好用

/usr/bin/mysql -h$HOSTADDRESS$ -u$ARG1$ -p$ARG2$ -N -e $ARG3$

ARG1 : user such as root
ARG2 : pws such as 123456
ARG3 : sql command such as "use mysql; show tables;"