# Inserting data to influxdb

**URL:** <https://community.influxdata.com/t/inserting-data-to-influxdb/12491>\
**Category:** InfluxDB 2\
**Tags:** influxdb\
**Created:** [January 3, 2020, 2:00am UTC](https://community.influxdata.com/t/inserting-data-to-influxdb/12491 "2020-01-03T02:00:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![varun.kadur](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/varun.kadur/32/4156_2.png) [@varun.kadur](https://community.influxdata.com/u/varun.kadur)\
**Post date:** [January 3, 2020, 2:00am UTC](https://community.influxdata.com/t/inserting-data-to-influxdb/12491/1 "2020-01-03T02:00:30Z")

</div>

Dear All,

I am Varun and I am very new to influxdb. I need your suggestion on how to insert records into influxdb

Scenario:  
We have records extracted from mysqldb in CSV format and we have another table in in Influxdb which is collecting live data from the sensors. Now I would like to insert records in CSV file to live database table. Please let me know how to do that.

Note: Inserting records using line protocol will be tough as we have many records in CSV file.

Thanks & Regards  
Varun

---

<div class="post-metadata">

**Author:** ![scott](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/scott/32/16492_2.png) [@scott](https://community.influxdata.com/u/scott)\
**Post date:** [January 3, 2020, 5:07pm UTC](https://community.influxdata.com/t/inserting-data-to-influxdb/12491/2 "2020-01-03T17:07:37Z")

</div>

This sounds like a great use case for using [Flux](https://docs.influxdata.com/flux/v0.50/) to either join the CSV data with your time series data or skip the CSV translation step and use the `sql.from()` function to pull the data directly from MySQL and join it with your sensor data.

> **[Query SQL data sources with InfluxDB | InfluxDB Cloud Documentation](https://docs.influxdata.com/influxdb/v2.6/query-data/flux/sql/)**
>
> The Flux sql package provides functions for working with SQL data sources. Use sql.from() to query SQL databases like PostgreSQL, MySQL, Snowflake, SQLite, Microsoft SQL Server, Amazon Athena, and Google BigQuery.