mysql终端执行SQL，忽略报错，打印结果

mysql -h 10.24.xx.xx  -u root -p  -vvv -s -N -f < test.sql > output 2>&1

参数说明：

-f   Continue even if we get an SQL error.

-v Write more. (-v -v -v gives the table output format).

-s Be more silent. Print results with a tab as separator,

-N  Don't write column names in results.

 

测试脚本test.sql

[root@instance-557laxgo ~]# cat test.sql
select version();
selects version();
select version();

　　

结果output

[root@instance-557laxgo ~]# cat output
--------------
select version()
--------------

+------------------------------+
| 5.7.17-baidu-rds-3.0.0.1-log |
+------------------------------+
1 row in set (0.01 sec)

--------------
selects version()
--------------

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'selects version()' at line 1
--------------
select version()
--------------

+------------------------------+
| 5.7.17-baidu-rds-3.0.0.1-log |
+------------------------------+
1 row in set (0.00 sec)

Bye