34,593
社区成员
发帖
与我相关
我的任务
分享
create table txt(txturl varchar(255));
insert into txt values('67210');
update txt set txturl = concat('http://www.xxx.com/BOOK/',txturl,'/',txturl,'.TXT');
select * from txt;
query result(1 records)
txturl
http://www.xxx.com/BOOK/67210/67210.TXT
create table txt(txturl varchar(255))
insert into txt values('67210')
update txt set txturl = ('http://www.xxx.com/BOOK/'+txturl+'/'+txturl+'.TXT');
select * from txt;