系列:
SELECT COLUMN_NAME as bt,column_comment as nr FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_ic' AND table_schema='golon' and column_comment like '*%'
类型:
SELECT COLUMN_NAME as bt,column_comment as nr FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_ic' AND table_schema='golon' and column_comment like '*%'
10/100 集成开关
应用:
SELECT COLUMN_NAME as bt,column_comment as nr FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_ic' AND table_schema='golon' and column_comment like '*%'
端口开关/网络接口
工作温度:
SELECT COLUMN_NAME as bt,column_comment as nr FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_ic' AND table_schema='golon' and column_comment like '*%'