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:
- Log into the remote server using the following shell command, making sure you replace the IP address with your server’s:
ssh [email protected]
- Log into MySQL using the following shell command, making sure you replace the username with the appropriate value:
mysql...