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

?

1 2 3 4

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

　　

结果output

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

[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