MySQL非交互式执行SQL

最新推荐文章于 2024-05-13 16:35:44 发布

钱亿堆

最新推荐文章于 2024-05-13 16:35:44 发布

阅读量1.3k

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/qianyidui/article/details/103123004

版权

MySQL 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

使用mysql -e “SQL语句”

[root@localhost mysql]# mysql -uroot -p'Aa123456@' -e "select user,host from mysql.user"
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| qianyidui     | %         |
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
[root@localhost mysql]#