34,587
社区成员
发帖
与我相关
我的任务
分享
insert into b select id,(select 'a','b','c','a','b','c') from a
insert b
select id ,(case when xh%3=0 then 'a' when xh%3=1 then 'b' when xh%3=2 then 'c' end)
from
(
select id,(select count(id) from a as tb where tb.id>a.id) as xh from a
)
as ta