mysql 修改字段中部分值
mysql> select * from syk_test;+-----------+-----------+
| user | host |
+-----------+-----------+
| repluser| % |
| syk | % |
| mysql.sys | localhost |
| root | localhost |
+-----------+-----------+
4 rows in set (0.00 sec)
mysql> update syk_test set host = replace (host,'local','my');
Query OK, 2 rows affected (0.00 sec)
Rows matched: 4Changed: 2Warnings: 0
mysql> select * from syk_test;
+-----------+--------+
| user | host |
+-----------+--------+
| repluser| % |
| syk | % |
| mysql.sys | myhost |
| root | myhost |
+-----------+--------+
4 rows in set (0.00 sec)
页:
[1]