New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

json from thingspeak to mysql #1

Open

ggrigon opened this issue Oct 10, 2018 · 1 comment

Labels

enhancement hacktoberfest help wanted

Owner

ggrigon commented Oct 10, 2018

i need a way to conver the json data from thingspeak.com to a mysql server

ggrigon added enhancement help wanted hacktoberfest labels

ggrigon assigned ggrigon and unassigned ggrigon

marcosnils commented Oct 10, 2018 •

edited

Loading

Why not downloading the CSV and importing to mysql using the built-in MYSQL functionality? . thingspeak provides CSV sources as well.

LOAD DATA LOCAL INFILE 'C:/tmp/mycsv.csv' 
INTO TABLE my_table 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
IGNORE 1 ROWS;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment