中止错误的多行SQL语句执行

数据存储

一、背景

经常会出现在命令行编写多行SQL过程中，发现语法有问题。
此时，需要中止错误的SQL语句，取消SQL执行。

二、实例

编写多行SQL，中途发现语法错误，可以通过\c来中止。
如若SQL内容较多，可以通过\p打印出已经编写的SQL语句。

1
2
3
4
5
6
7
mysql> select 123
    -> \p
--------------
select 123
--------------

    -> \c

三、扩展知识

更多mysql命令如下:

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
26
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

四、参考文档

本文标题:中止错误的多行SQL语句执行

文章作者:

发布时间:2016-05-25, 20:36:00

最后更新:2021-07-01, 12:25:31

原始链接:http://yeshaoting.cn/article/database/%E4%B8%AD%E6%AD%A2%E9%94%99%E8%AF%AF%E7%9A%84%E5%A4%9A%E8%A1%8CSQL%E8%AF%AD%E5%8F%A5%E6%89%A7%E8%A1%8C/

许可协议: "署名-非商用-相同方式共享 4.0" 转载请保留原文链接及作者。

文章目录
  1. 一、背景
  2. 二、实例
  3. 三、扩展知识
  4. 四、参考文档
|