[MySql]insert...select 8/10

insert into sto_stocks2(ym,prdt,whouse,kind,qty,indate,inuser,cdate,cuser)
select '200706' as ym,prdt,whouse,'101' as kind,qty1 as qty,indate,inuser,cdate,cuser from sto_checks where date_format(pdate,'%Y%m')='200706';