重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: mysql 执行命令提示符下执行操作系统命令 [打印本页]

作者: 郑全 时间: 2026-3-15 14:15
标题: 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

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)