update dashboard set data = replace(data,‘$host‘,‘$ip‘)
update dashboard set data = replace(data,‘instance‘,‘ip‘)update dashboard set data = replace(data,‘instance="$host"‘,‘ip="$ip",port="$port"‘) where slug like ‘mysql%‘ and plugin_id=‘pmm-app‘;replace函数: http://www.mysqltutorial.org/mysql-string-replace-function.aspx
原文：https://blog.51cto.com/l0vesql/2364090