系列:
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 '*%'