Answered step by step
Verified Expert Solution
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
collector is 1
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 water is 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started