Question: Install MySQL or Oracle server free version, read their getting started manuals, and run the following queries in SQL (the queries are from MySQL 8.0
Install MySQL or Oracle server free version, read their getting started manuals, and run the following queries in SQL (the queries are from MySQL 8.0 Reference Manual): Question 1 CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); Question 2 INSERT INTO pet VALUES ('Puffball', 'Diane', 'hamster, f, '1990-03-30, NULL); INSERT INTO pet VALUES ('Fluffy', 'Harold', 'cat', 'f', '1993-02-04', NULL); INSERT INTO pet VALUES ('Bowser', 'Diane', 'bird','f','1979-08-31','1985-07-29'); Question 3: SELECT FROM pet; Question 4: SELECT * FROM pet WHERE birth >= '1990-01-01'; Question 5: DELETE FROM pet WHERE birth>1990-01-01'; SELECT * FROM pet wHERE birth >= '1990-01-01
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
