CONNECT BY ROWNUM

to_char(trunc(sysdate) + (ROWNUM - 1) / (24 * 6), 'hh24:mi') as tradesec FROM DUAL CONNECT BY ROWNUM <= 24 * 6

转换成mysql

请提供一下所使用的mysql版本号,
如果是mysql8.0以上的话,可以使用with递归

with RECURSIVE cte as (
select cast('00:00:00' as time) t,1 lvl union all
select date_add(t, interval '00:10:00' hour_second),lvl+1 from cte where lvl<=24*6-1
)
select time_format(t,'%H:%i') t from cte