mysql中执行 linux shell命令（本地shell执行）

分手后的思念是犯贱 2021-07-28 17:50 1170阅读 0赞

> mysql> help  
> For information about MySQL products and services, visit:  
>    http://www.mysql.com/  
> For developer information, including the MySQL Reference Manual, visit:  
>    http://dev.mysql.com/  
> To buy MySQL Network Support, training, or other products, visit:  
>    https://shop.mysql.com/
> 
> 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.

从帮助信息可以看到 system 命令可以执行 还有 \\! 也是同样的效果

测试一下：

mysql> system ls
    cjjcpptest  fork  main.cpp
    
    mysql> \! ls
    cjjcpptest  fork  main.cpp
    
    mysql> \! ping localhost;
    PING localhost (127.0.0.1) 56(84) bytes of data.
    64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.000 ms
    64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.000 ms
    64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.000 ms
    64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.000 ms
    64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.000 ms
    
    --- localhost ping statistics ---

成功执行shell命令。注意是 本地shell执行