标签：数据库 ida2a2 学习 WTTYPEDEFINITION 1493 611205 设计 where select
select * from wtpartmaster ;
select * from wtpartmaster where ida2a2 = 611205;
select * from wtpart where IDA3MASTERREFERENCE = 611205;
select * from wtpartusagelink where ida3b5 = 611205;
select * from WTTYPEDEFINITION where ida2a2 = 1493;
select IDA3MASTERREFERENCE from WTTYPEDEFINITION where ida2a2 = 1493;
select IDA3DOMAINREF from WTTYPEDEFINITION where ida2a2 = 1493;
select * from WTTYPEDEFINITIONMaster where ida2a2 = 1488;
select * from ADMINISTRATIVEDOMAIN where ida2a2=7;
select * from STRINGDEFINITION ;
select * from STRINGDEFINITION where IDA3DOMAINREF = 7;
select distinct(CLASSNAMEKEYA4) from STRINGVALUE where rownum<10000;
-- 在表中查询 特定类型零件的 数据
select * from STRINGVALUE where CLASSNAMEKEYA4 = 'wt.part.WTPart' and ida3a4 = 475862 and rownum<100;
select * from STRINGDEFINITION where ida2a2 = 133032;
select * from STRINGDEFINITION where ida2a2 = 20629;
select * from wtpart where ida2a2 = 475862;
标签：数据库,
ida2a2,
学习,
WTTYPEDEFINITION,
1493,
611205,
设计,
where,
select
From： https://www.cnblogs.com/ya-cpp/p/16777011.html