查询influxdb表中字段

> show field keys  from status_consume
name: status_consume
fieldKey fieldType
-------- ---------
details  string
num      string

> show tag keys  from status_consume
name: status_consume
tagKey
------
jg_id
location

操作influxdb

influx

show databases

use db_name

show measurements

select * from jg_system_info order by time desc limit 10

select distinct(jg_id) from jg_system_info

黑龙江2300、212300010016--->湖南4300、214300010013

insert data_task,exe_status='200',jg_id='212300010016',location='2300',range='396' address='192.168.110.173:5000',d_jg_id='214300010013',d_location='4300',desc='转发至目的地路由：192.168.110.173:5000 成功！',pro_time='2021-09-07 00:58:50.977134',task_id='23002109060058509771343';

insert data_consume,jg_id=214300010013,location=4300 details="[{"task_id": "23002109060058509771343", "src_system_id": "212300010016", "schema_id": "01030002"}]",num="1"

tag与tag之间用逗号分隔；field与field之间用逗号分隔

tag与field之间用空格分隔

tag都是string类型，不需要引号将value包裹

field如果是string类型，需要加引号