摘要:
正确语句:select int(cast(substr(dpt_leader_ids,4,posstr(dpt_leader_ids,',0)')-4) as varchar(8))), d.* from zm_plan_day p left join pub_dpt d on p.dpt_id = d.organ_id where id = 'PD00001880';错误语句(少了cast转换varchar):select int(substr(dpt_leader_ids,4,posstr(dpt_leader_ids,',0)')-4))) 阅读全文
2013年9月23日 #