SQL replace
表名 tb_orderid:1 name:我是xxx age:19id主键自增 name唯一索引1.select replace(name,‘xxx’,‘sx’) from tb_order--------->我是sx2.update tb_order set name = replace(name,‘xxx’,‘sb’)数据库结果 id:1 name:我是sb age:193. replace into tb_order (id ,name) values(null,
复制链接