mysql非交互执行sql

mysql -e 非交互方式执行sql脚本
● 同时显示语句本身：-v
● 增加查询结果行数：-vv
● 增加执行时间：-vvv

D:\dev\mysql-8.0.17-winx64\bin>mysql -uroot -proot -e "select host,user from mysql.user"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+

D:\dev\mysql-8.0.17-winx64\bin>mysql -uroot -proot -e "select host,user from mysql.user" -v
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
select host,user from mysql.user
--------------

+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+

D:\dev\mysql-8.0.17-winx64\bin>mysql -uroot -proot -e "select host,user from mysql.user" -vv
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
select host,user from mysql.user
--------------

+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

Bye

D:\dev\mysql-8.0.17-winx64\bin>mysql -uroot -proot -e "select host,user from mysql.user" -vvv
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
select host,user from mysql.user
--------------

+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

Bye