表1字段截取联查表2对应表一每一个截取出来的值都有对应的表2数据

Question

现在数据已经出来了,但是写循环的时候错误解决不了

declare @i int;
set @i=1;
while @i<150;
begin
select * from cloud_airline_pos where cloud_airline_pos.name in (
select
SUBSTRING_INDEX(SUBSTRING_INDEX((
select cloud_airline_sim.airline from cloud_airline_sim where cloud_airline_sim.id=@i),',',help_topic_id+1),',',-1) as num
from
mysql.help_topic
where help_topic_id < LENGTH((
select cloud_airline_sim.airline from cloud_airline_sim where cloud_airline_sim.id=@i))-LENGTH(REPLACE((
select cloud_airline_sim.airline from cloud_airline_sim where cloud_airline_sim.id=@i),',',''))+1
)
set @i=@i+1
end

Answer 1

https://blog.csdn.net/linhaogogogo/article/details/69569387