《k3常遇问题后台数据库资料 3》由会员分享，可在线阅读，更多相关《k3常遇问题后台数据库资料 3（16页珍藏版）》请在金锄头文库上搜索。
1、K3常遇问题后台数据库资料 3K3常遇问题后台数据库资料(3) 2011年06月30日-改辅助属性 select * from t_auxitem where fitemid=2174 select * from t_item_3013 where fitemid=2174 select * from t_itemclass where fitemclassid=3013 -update t_auxitem set fname= where fitemid= select * from t_icitem where substring(fnumber,1,1)=j select * from
2、t_icitem where substring(fnumber,1,1) in (s,o) select * from t_auxitem where fitemclassid=3007 -改BOM损耗率 select * from sheet1$ select * from icbomchild UPDATE icbomchild SET icbomchild.fscrap=sheet1$.fscrap select * FROM icbomchild INNER JOIN sheet1$ ON icbomchild.fentryid=sheet1$.fentryid and icbomc
3、hild.finterid=sheet1$.finterid -采购订单及相关厂商及业务员 select * from t_emp select * from t_organization select * from seorder where fbillno=sh081120 select * from seorderentry where finterid=2832 select a.fbillno,b.faddress,b.fname,c.fname,d.famount,d.f date from seorder a inner join t_organization b on a.fc
4、ustid=b.fitemid left join t_emp c on c.fitemid=a.fempid left join seorderentry d on d.finterid=a.finterid order by b.fname,b.faddress where substring(b.fnumber,1,1)=b select * from t_organization -将膨胀螺栓-内改为膨胀螺栓-外 select * from icbom where fparentid=1044 select * from icbomchild where finterid=15484
5、and finterid=15729 select * from icbomgroup where finterid=1044 select * from t_icitem where fnumber=sl208085z select * from t_icitem where fnumber=sl208090z select * from icbomchild a inner join icbom b on a.finterid=b.finterid inner join icbomgroup c on c.finterid=b.fparentid where c.finterid= dro
6、p table sheet1$ select * from sheet1$ update sheet1$ set fitemid=17529 select * from icbomchild select a.fitemid,a.fentryid,a.finterid,c.fbomnumber,b.fnu mber,b.fname ,b.fmodel,d.fname -update icbomchild set fitemid=17259 where fitemid in (select a.fitemid from icbomchild a left join t_icitem b on a
7、.fitemid=b.fitemid left join icbom c on c.finterid=a.finterid left join icbomgroup d on d.finterid=c.fparentid where a.fitemid in (12274) and c.fparentid in (1051,1053,1056) UPDATE icbomchild SET icbomchild.fitemid=12276 -select * FROM sheet1$ INNER JOIN icbomchild ON icbomchild.fitemid=sheet1$.fite
8、mid and icbomchild.fentryid=sheet1$.fentryid and icbomchild.finterid=sheet1$.finterid -抓bom资料 select * from icbomgroup where substring(fname,1,3)=支柱组 select * from icbom select * from icbomchild select aa.fnumber,aa.fname,aa.fmodel,bb.fnumber,bb.fname, bb.fmodel,bb.fqty from (select b.finterid,d.fnu
9、mber,d.fname,d.fmodel from icbomgroup a left join icbom b on a.finterid=b.fparentid left join t_icitem d on d.fitemid=b.fitemid where substring(a.fname,1,3)=支柱组 or substring(a.fname,2,3)=螺栓组) aa left join (select c.finterid,d.fnumber,d.fname,d.fmodel,c.fqty from icbomgroup a left join icbom b on a.f
10、interid=b.fparentid left join icbomchild c on c.finterid=b.finterid left join t_icitem d on d.fitemid=c.fitemid where substring(a.fname,1,3)=支柱组 or substring(a.fname,2,3)=螺栓组) bb on aa.finterid=bb.finterid select b.finterid,d.fnumber,d.fname,d.fmodel from icbomgroup a left join icbom b on a.finterid
11、=b.fparentid left join t_icitem d on d.fitemid=b.fitemid where substring(a.fname,1,3)=支柱组 -改bom中支柱中螺栓组的数量 select * from icbom a left join icbomchild b on a.finterid=b.finterid where b.fitemid =12195 select * -update icbomchild set fqty=2,fauxqty=2 from icbom a left join icbomchild b on a.finterid=b.
12、finterid where fparentid in (1044,1047,1049) and b.fitemid =12196 select * from icbomchild where fitemid=12196 -update icbomchild set fitemid=12198 where fitemid=12224 and finterid in (14468,14471,14474,14483,14486,14489, 14498,14501,14504,14513,14516,14519) select * from t_icitem where fnumber=sl10
13、8020Z select * from t_auxitem where fitemclassid=3027 and fname=- select * from icinventory where fitemid=12102 select * from icbomgroup select * from dairysalary select * from daysalary where fempid=207010 select * from manurec where fempid=207010 select * from manurecx where fempid=207010 select *
14、 from manuprice where fnumber=cbz01 delete from manurecx where fworkdate=2008-10-30 delete from manurec where fworkdate=2008-10-30 delete from dairysalary where fworkdate=2008-10-30 -改物料名称 select fitemid,fname from t_icitemcore where fname like %牛腿%园% select fitemid,ffullname from t_icitembase where ffullname like %牛腿%园% UPDATE t_item SET t_item.fname=sheet2$.fname,t_item.ffullname=sheet2 $.ffullname FROM t_item INNER JOIN sheet2$ ON t_item.fitemid=sheet2$.fitemid UPDATE t_icitemcore SET t_icitemcore.fname=sheet2$.fname FROM t_icitemcore INNER JOIN sheet2$ ON t_icitemc
