Question: ID - Unsigned integer Name - Variable-length string with maximum 40 characters Product Type - Fixed-length string with maximum 3 characters OriginDate - Year, month,

 ID - Unsigned integer Name - Variable-length string with maximum 40

ID - Unsigned integer Name - Variable-length string with maximum 40 characters Product Type - Fixed-length string with maximum 3 characters OriginDate - Year, month, and day Weight - Unsigned decimal number Place your CREATE TABLE statement before the INSERT and SELECT statements. Run your solution and verify the result table contains the three inserted rows. 1 CREATE TABLE Product 2 ID int, 3 Name varchar(40), 4 Product Type char(3), 5 Originaldate DATE, 6 Weight DECIMAL (5,2) 7); 8 9 INSERT INTO Product (ID, Name, ProductType, OriginDate, Weight) VALUES 10 (100, 'Tricorder', 'COM', '2020-08-11', 2.4), 11 (200, 'Food replicator', 'FOD', '2020-09-21', 54.2), 12 (300, 'Cloaking device', 'SPA', '2019-02-04', 177.9); 13 14 SELECT * 15 FROM Product; Run Reset code ERROR 1054 (42522) at line 9: Unknown column 'OriginDate' in field list

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!