mysql 执行命令提示符下执行操作系统命令

郑全

至少有两种方式，一个使用\! ,一个使用 system

1. mysql > \! ls -ltr

2. mysql> system pwd

下面示例：

mysql> system ip add
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host noprefixroute
       valid_lft forever preferred_lft forever
2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:bb:2c:79 brd ff:ff:ff:ff:ff:ff
    altname enp3s0
    altname enx000c29bb2c79
    inet 192.168.133.10/24 brd 192.168.133.255 scope global noprefixroute ens160
       valid_lft forever preferred_lft forever
    inet6 fe80::20c:29ff:febb:2c79/64 scope link noprefixroute
       valid_lft forever preferred_lft forever
mysql> \! ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host noprefixroute
       valid_lft forever preferred_lft forever
2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:bb:2c:79 brd ff:ff:ff:ff:ff:ff
    altname enp3s0
    altname enx000c29bb2c79
    inet 192.168.133.10/24 brd 192.168.133.255 scope global noprefixroute ens160
       valid_lft forever preferred_lft forever
    inet6 fe80::20c:29ff:febb:2c79/64 scope link noprefixroute
       valid_lft forever preferred_lft forever