Question: Requirements 1. Using the database structure created you created in Module 03, use the MySQL CLI to issue SQL INSERT statements to populate the tables.


Requirements 1. Using the database structure created you created in Module 03, use the MySQL CLI to issue SQL INSERT statements to populate the tables. All tables are to have at least 10 records each. Take a screen shot of some of the INSERT queries you use to populate the tables. 2. Issue MySQL CLI command(s) that show all the records your database table(s). Take a screen shot of the outputs of these command(s). 3. Using the MySQL CLI, issue the following SQL queries to test the database. Take a screen shot of each one that you use successfully. a. A SELECT query that outputs the entire contents of a table. b. A SELECT query that outputs only two fields (columns) from all of the records in a table. c. A SELECT query that outputs all fields of records that match a condition in a WHERE clause. d. A SELECT query that outputs two fields from all records that match a condition in a LIKE clause. e. A SELECT query that matches a condition in one table and outputs all fields of related records in a second table. The two tables must have a relation or you can use a JOIN statement if desired. f. An UPDATE query that updates all records matching a WHERE condition. g. A DELETE query that removes all records matching a WHERE condition. This query must leave some records remaining in the table. h. An INSERT query that adds a record to one of the table(s) in the database. customers idcustomers INT customername VARCHAR(45) customer address VARCHAR(45) customer phone VARCHAR(45) customer email VARCHAR(45) vehicles_idvehicles INT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
