Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Design With Microcomputer Applications

Authors: Glenn A. Jackson

1st Edition

0137718411, 978-0137718412

More Books

Students also viewed these Databases questions

Question

Does it avoid use of underlining?

Answered: 1 week ago

Question

=+Where do you want to live and work?

Answered: 1 week ago

Question

=+1 Where are the best places in the world to live (and work)?

Answered: 1 week ago