Creating a table in the database
We have created a database in the cloud and have connected via MySQL Workbench. As a next step, we are going to create a table via MySQL Workbench:
- Connect to the database via MySQL Workbench.
- Create a database with the following command and click the lightning symbol, as shown in the figure that follows:
CREATE DATABASE address;
Figure 8.23 – Creating a database
- Execute the
USE addresscommand in order to switch databases:
USE address;
Figure 8.24 – USE address
- Create an address table:
CREATE TABLE address (id INT, address VARCHAR(20));
Figure 8.25 – Creating a table
We have created an address table, and for the next step, we are going to insert data into the table.
- Execute the following script to insert data into the table:
INSERT INTO address (id,address) VALUES(1,"Germany"...
