mysql replace用法

1. replace into 

   插入记录

mysql> select * from testreplace;

mysql> replace into testreplace(id,name) values(1, '1'), (2, '2'), (3,'3');

mysql> select * from testreplace;

 

1. replace(object,search,replace) 

   替换字符串