作者：枫殇忆华年 | 来源：互联网 | 2014-06-09 00:50
mysql使用replace命令批量替换mysql>select*fromtest1;+------+---------+www.2cto.com|id|name|+------+---------+|1|aaaKaaa||2|bbbKbbb||3|cccKccc|+...
mysql> select * from test1;
+------+---------+ www.2cto.com
| id | name |
+------+---------+
| 1 | aaaKaaa |
| 2 | bbbKbbb |
| 3 | cccKccc |
+------+---------+
3 rows in set (0.00 sec)
mysql> update test1 set name=replace(name,&＃39;K&＃39;,&＃39;211.99.224.138&＃39;);
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> select * from test1;
+------+----------------------+
| id | name |
+------+----------------------+
| 1 | aaa211.99.224.138aaa |
| 2 | bbb211.99.224.138bbb |
| 3 | ccc211.99.224.138ccc |
+------+----------------------+
3 rows in set (0.00 sec)
![[附源码]计算机毕业设计JAVAjsp医药管理信息系统](https://img3.php1.cn/3cdc5/63cc/3b4/50c0ad62c8b7c2f1.png)
京公网安备 11010802041100号