mysql 命令行选项

发布于 2024-12-23 01:05:17 字数 136 浏览 1 评论 0原文

mysql 中的命令行选项 -e 或 --execute 用于在 shell 提示符本身中执行命令。如果查询不成功，有没有办法打印错误（如果输出的数字为零？）一样

Empty set (0.89 sec)

原文

The commandline option -e or --execute in mysql is used to execute commands in shell prompt itself. Is there a way to print an error if the query was not successful (if the number if output is zero?)
Just like

Empty set (0.89 sec)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

那片花海 2024-12-30 01:05:18

mysql 默认情况下已经打印出错误消息。如果发生错误，它也会以大于 0 的退出代码退出：

$ mysql -e "SHOW VARIABLES LIKE 'version' THIS WON'T WORK"
ERROR 1064 (42000) at line 1: 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 'THIS WON'T WORK' at line 1
$ echo $?
1
$ mysql -e "SHOW VARIABLES LIKE 'version'"
+---------------+------------+
| Variable_name | Value      |
+---------------+------------+
| version       | 5.5.19-log |
+---------------+------------+
$ echo $?
0

mysql already prints out error messages by default. It also exits with an exit code larger than 0 if an error occured:

$ mysql -e "SHOW VARIABLES LIKE 'version' THIS WON'T WORK"
ERROR 1064 (42000) at line 1: 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 'THIS WON'T WORK' at line 1
$ echo $?
1
$ mysql -e "SHOW VARIABLES LIKE 'version'"
+---------------+------------+
| Variable_name | Value      |
+---------------+------------+
| version       | 5.5.19-log |
+---------------+------------+
$ echo $?
0

回复收藏 0 原文

~没有更多了~