---
title: "SQL Temperatur Daten Logger"
url: "https://maker.wiznet.io/jaden/projects/sql-temperatur-daten-logger/"
markdown_url: "https://maker.wiznet.io/jaden/projects/sql-temperatur-daten-logger/md"
type: "UCC: User Created Content"
author: "Intelligent Ideas"
author_url: "http://www.ii-intelligent-ideas.com/NewsBlog/sql-temperatur-daten-logger/"
editor: "WIZnet"
editor_url: "https://maker.wiznet.io/"
original_author: "Intelligent Ideas"
original_url: "http://www.ii-intelligent-ideas.com/NewsBlog/sql-temperatur-daten-logger/"
published: "2023-06-02"
language: "en"
likes: 0
views: 200
comments: 0
source: "WIZnet Makers (https://maker.wiznet.io/)"
---

# SQL Temperatur Daten Logger

> data logger

Original author: Intelligent Ideas (source: http://www.ii-intelligent-ideas.com/NewsBlog/sql-temperatur-daten-logger/)

## Article

This article explains how to set up an SQL temperature data logger using an Arduino UNO. The following steps were implemented:

1. Setting up a database named "userdb" with a table named "temp_data." The table has two columns: an automatic SQL timestamp "datetime" and the temperature value "temp_value."

2. Programming the Arduino UNO, which includes a button, a temperature sensor, and an LED.

3. Establishing the basic connection for inserting data into the database using Ethernet and MySQL libraries.

4. Adding code to incorporate a temperature sensor (DS18B20) to read temperature values.

5. The basics of SQL data logging with an Arduino UNO and a temperature sensor are derived from the book "MySQL for the Internet of Things" by Dr. Charles Bell.

6. Additionally, an example is provided on how to read data from a humidity and temperature sensor (DHT22) and construct an SQL string to send the data.

Please note that the provided code snippets are in German, and the report refers to specific libraries and sensor configurations.

[Embedded media](https://www.youtube.com/embed/_ZDduQ_046k)

---

Source: https://maker.wiznet.io/jaden/projects/sql-temperatur-daten-logger/