项目中,需要涉及到数据迁移。 正好需要人大金仓数据字段和mysql字段进行匹配。所有需要进行字段查询。 使用sorttables.js 进行字段排序然后 进行匹配。
sql 语句
select
a.attnum,
a.attname as field,
a.attlen as length,
a.atttypmod as lengthvar,
a.attnotnull as notnull,
b.description as comment
from
sys_class c,
sys_attribute a
left outer join sys_description b on
a.attrelid = b.objoid
and a.attnum = b.objsubid
where
c.relname = '表名'
and a.attnum > 0
and a.attrelid = c.oid
order by
a.attnum;
查询结果