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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!