你的字段是什么类型的啊?字符型?update 表 set p_b='b/c'+right(p_a ,1)
create table b( p_a varchar(10), p_b varchar(10) )insert into b values('a/1',null) insert into b values('a/2',null) insert into b values('a/3',null)select * from bupdate b set p_b='b/c'+right(p_a,1)select * from b
你的字段是什么类型的啊?字符型?update 表 set p_b='b/c'+right(p_a ,1)
create table a (p_a varchar(8),p_b varchar(8)) insert a values ('a/1',null) insert a values ('a/2',null) insert a values ('a/3',null)update a set p_b=replace(p_a,'a/','b/c') where p_b is null
谢谢大家 我这边具体是这样的 a b upload_images/2005618195342.jpg null我想转化成 a b upload_images/2005618195342.jpg upload_slt/small2005618195342.jpg 图片的名加个small,文件夹换一个
update a set p_b=replace(p_a,'upload_images/','upload_slt/small') where p_b is null--这个where子句,在你的需求中应该不用加
create table b(
p_a varchar(10),
p_b varchar(10)
)insert into b values('a/1',null)
insert into b values('a/2',null)
insert into b values('a/3',null)select * from bupdate b set p_b='b/c'+right(p_a,1)select * from b
insert a values ('a/1',null)
insert a values ('a/2',null)
insert a values ('a/3',null)update a set p_b=replace(p_a,'a/','b/c') where p_b is null
我这边具体是这样的
a b
upload_images/2005618195342.jpg null我想转化成
a b
upload_images/2005618195342.jpg upload_slt/small2005618195342.jpg 图片的名加个small,文件夹换一个
where p_b is null--这个where子句,在你的需求中应该不用加