Nagios批量更换管理员
Nagios批量更换管理员
select * from host where host_alias like "%name%"
select host_name, host_alias from host where host_name LIKE "%172.2.129.61%";
替换：
UPDATE host
SET host_alias = (
REPLACE (
host_alias,
"name1",
"name2"
)
)
WHERE
host_name LIKE "%中心%";
增加：
UPDATE host
SET host_alias = (
concat (
host_alias,
"/name"
)
)
WHERE
host_name LIKE "%129.61%";
select * from host where host_alias like "%name%"
select host_name, host_alias from host where host_name LIKE "%172.2.129.61%";
替换：
UPDATE host
SET host_alias = (
REPLACE (
host_alias,
"name1",
"name2"
)
)
WHERE
host_name LIKE "%中心%";
增加：
UPDATE host
SET host_alias = (
concat (
host_alias,
"/name"
)
)
WHERE
host_name LIKE "%129.61%";
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30936525/viewspace-2097965/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
整理月平均性能数据
请登录后发表评论
登录
全部评论
