22,209
社区成员
发帖
与我相关
我的任务
分享
insert into b(字段) select a1 from a where a1=right(a1,3)
insert into b(字段) select a1 from a where a1=right('桂B025',3)
insert into b(b1)
select right(rtrim(a1),3) from a
insert tb
select right(a1,3) from a
SELECT RIGHT('桂B025',3)
------
025
(所影响的行数为 1 行)