mysql — The MySQL Command-Line Client If the  connect  command specifies a host name argument, that host takes precedence over any  --dns- srv-name  option given at  mysql  startup to specify a DNS SRV record. Change the string that  mysql  interprets as the separator between SQL statements. The default is the semicolon character ( ; ). The delimiter string can be specified as an unquoted or quoted argument on the  delimiter  command line. Quoting can be done with either single quote ( ’ ), double quote ( " ), or backtick ( ‘ ) characters. To include a quote within a quoted string, either quote the string with a different quote character or escape the quote with a backslash ( \ ) character. Backslash should be avoided outside of quoted strings because it is the escape character for MySQL. For an unquoted argument, the delimiter is read up to the first space or end of line. For a quoted argument, the delimiter is read up to the matching quote on the line. mysql  interprets instances of the delimiter string as a statement delimiter anywhere it occurs, except within quoted strings. Be careful about defining a delimiter that might occur within other words. For example, if you define the delimiter as  X , it is not possible to use the word  INDEX  in statements.  mysql interprets this as  INDE  followed by the delimiter  X . When the delimiter recognized by  mysql  is set to something other than the default of  ; , instances of that character are sent to the server without interpretation. However, the server itself still interprets  ;  as a statement delimiter and processes statements accordingly. This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 25.1, “Defining Stored Programs” ). Edit the current input statement.  mysql  checks the values of the  EDITOR  and  VISUAL  environment variables to determine which editor to use. The default editor is  vi  if neither variable is set. The  edit  command works only in Unix. Send the current statement to the server to be executed and display the result using vertical format. Exit  mysql . Send the current statement to the server to be executed. Disable output paging. See the description for  pager . The  nopager  command works only in Unix. Disable output copying to the tee file. See the description for  tee . •  delimiter  str ,  \d  str •  edit ,  \e •  ego ,  \G •  exit ,  \q •  go ,  \g •  nopager ,  •  notee ,  435