字符串追加
查询
select 'a' || name as name, 'b' || age as age from mytable;
更新
update mytable set name = 'a' || name, age = 'b' || age;
字符串替换
update mytable set name = replace(name, 'cat', 'dog') where id=1 ;
正文完
微信搜一搜“奇悦电脑科技”或扫描二维码关注我们
