Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

tryin to add a new row (number 5) into the abaloness table collector is 1 water is 2 Helght decimal (4,3), Whole_weight decisal (5,4), shucked_weight

tryin to add a new row (number 5) into the abaloness table
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
collector is 1
water is 2
Helght decimal (4,3), Whole_weight decisal (5,4), shucked_weight decimal (5,5), viscera_weight decinal (5,5), shell_weight decimali (4,3), Rings int, Collector int, collector_first varchar(20), collector_last varchar (20), collector_organization varchar (se), Water int, water_region varchar(se), Feb_tenp decina1 (3,1)) select - fron Abaloness; use world; create table Abaloness( Abalone_id int, Gender char(1), Length decinal (4,3), Dianeter decinal (4,3), Height decimal (4,3), whole_welght decimal (5,4), Shucked_weight decimal (5,5), viscera_veight decinal (5,5), Shell_weight decinal (4,3), Rings int, Collector int, collector_first varchar (2e), collector_last varchar(20), Collector oreanization varchar (5). 5. Insert the following new data into the database Conector: jan uaom, University or Houston Water info: Florida Atlantic Coast; 71.8 degrees Fahrenheit. insert into abaloness (shucked weight,gender,length, diameter, height, whole_weight, viscera weight, shell weight, rings, collect or first,collector_last, collector_organization, water_region, feb temp) values (0.9455, 'M', 0.710,0.555,0.195,1.9485,0.3765,0.495,12,'Jan','Odom','University of Houston', 'Florida Atiantic Coast', 71.8); select " from abaloness

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

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions

Question

13-1 How does building new systems produce organizational change?

Answered: 1 week ago