Creating tables in InfluxDB via Terminal

mysql sql centos influxdb
gordon sung picture gordon sung · Sep 9, 2016 · Viewed 9.9k times · Source

Are there tutorials online that teaches you how to create tables and input values in InfluxDB? How would you create a table and insert values into them?

Answer

Michael Desa picture Michael Desa · Sep 12, 2016

InfluxDB doesn't really have the concept of a table. Data is structured into series, which is composed of measurements, tags, and fields.

Measurements are like buckets.

Tags are indexed values.

Fields are the actual data.

Data is written into InfluxDB via line protocol. The structure of line protocol is as follows

<measurement>,<tag>[,<tags>] <field>[,<field>] <timestamp>

An example of a point in line protocol:

weather,location=us-midwest temperature=82 1465839830100400200

To insert data into the database you'll need to issue an HTTP POST request to the /write endpoint, specifying the db query parameter.

For example:

curl -XPOST http://localhost:8086/write?db=mydb --data-binary "weather,location=us-midwest temperature=82 1465839830100400200"

For more information see the Getting Started section of the InfluxDB docs.

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN in MySQL?

Read More