遇到的问题,有一段sql语句:
select a.l_date as deal_date,0 as deal_time,a.vc_deal_no as deal_no,a.l_entrust_serial_no as entrust_no,
a.c_market_no as market_no,a.vc_realdeal_code as stock_code,a.vc_report_code as etf_first_code,concat('0',a.c_entrust_direction) as entrust_direction,
a.l_deal_amount as deal_amount,a.en_deal_balance as deal_balance,a.en_deal_price as deal_price,a.en_fee as total_fee,b.l_extsystem_id as module_id,
b.vc_third_reff as third_remark,b.l_operator_no as operator_no,b.l_batch_serial_no as batch_no,a.vc_report_direction as report_direction "
from tetfrealdeal a, tentrusts b where a.l_entrust_serial_no = b.l_entrust_serial_no and b.l_operator_no in ({{operator_no_list}})
我想把 (as空格key空格)中的key(如deal_date,deal_time等)全部提取出来返回给其他函数,这应该怎么写shell脚本呢,是遍历这条sql,还是有啥字符截取的方法呢?