influx 学习 - 表 measurement

influx 学习 - 表 measurement

influx 中的表 measurement 相当于 mysql 中的 table

查看所有表

> use test
Using database test
> show measurements
name: measurements
name
----
t_user
> 

或者

SHOW MEASUREMENTS [ON <database_name>] 
			[WITH MEASUREMENT <regular_expression>] 
			[WHERE <tag_key> <operator> 
			['<tag_value>' | <regular_expression>]] 
			[LIMIT_clause] [OFFSET_clause]

> show measurements on test
name: measurements
name
----
t_user
> 

创建 measurement

直接插入一条数据库即可

insert table,[tag=key=val] [field=key=value]

tag 和 filed 中间以空格分开

> insert t_user,name=test age=12,address="上海市徐汇区"

复制 measurement

> select * into t_user_bak from t_user
name: result
time written
---- -------
0    1
> select * from t_user_bak
name: t_user_bak
time                address age name
----                ------- --- ----
1621472886951647126 上海市徐汇区  12  test
> 

删除 measurement

> drop measurement t_user_bak
> show measurements
name: measurements
name
----
t_user