Working with SQL

Creating tables in SQL falls into a class of operations called data definition language (DDL). However, working with data falls into a class called data manipulation language (DML). DML falls into four categories that are frequently called create, retrieve, update, and delete (CRUD). Let’s take a brief look at CRUD.

Project 2 – Inserting data into a MySQL table

We must create operations and insert data into a table. This uses an INSERT statement in SQL. The script for this project is available at https://github.com/PacktPublishing/Arduino-Data-Communications/blob/main/chapter-5/MySQL-Create-Tables/insert_data.sql.

Follow these steps to insert data into the tables:

1. Log into the remote server using the following shell command, making sure you replace the IP address with your server’s:

   ssh username@192.168.68.127

2. Log into MySQL using the following shell command, making sure you replace the username with the appropriate value:

   mysql...