请问哪位有没有好的办法实现修改一条语句。
以知表
create table a (
id int,
name varchar(20),
hig varchar(20)
)
insert into (1,'aa','aa');
insert into (1,'bb','bb');
insert into (1,'cc','cc');
insert into (1,'dd','dd');
insert into (2,'aa','aa');
insert into (2,'bb','bb');
insert into (2,'cc','cc');
insert into (2,'dd','dd');
......
我现在想把所有的name列的值修改成name+hig列的值
以知表
create table a (
id int,
name varchar(20),
hig varchar(20)
)
insert into (1,'aa','aa');
insert into (1,'bb','bb');
insert into (1,'cc','cc');
insert into (1,'dd','dd');
insert into (2,'aa','aa');
insert into (2,'bb','bb');
insert into (2,'cc','cc');
insert into (2,'dd','dd');
......
我现在想把所有的name列的值修改成name+hig列的值
是concat