系列:
SELECT COLUMN_NAME as bt,column_comment as nr FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_cgq_b_zycgq' 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_cgq_b_zycgq' 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_cgq_b_zycgq' AND table_schema='golon' and column_comment like '*%'
返回顶部