current code does not work.. Jan 1, 2015Make the following updates:1. Change the height to 15.6 for horse with ID 2.2. Change the registered name to Lady Luck and birth date to May 1, 2015 for...


current code does not work..


The Horse table has the following columns:<br>• ID - integer, auto increment, primary key<br>RegisteredName - variable-length string<br>• Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred<br>Height - decimal number, must be 2 10.0 and < 20.0<br>• BirthDate - date, must be > Jan 1, 2015<br>Make the following updates:<br>1. Change the height to 15.6 for horse with ID 2.<br>2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4.<br>3. Change every horse breed to NULL for horses born on or after December 22, 2016.<br>302990.1511538.gx3zgy7<br>LAB<br>12.16.1: Update rows in Horse table<br>ACTIVITY<br>Main.sql<br>Load default<br>1 UPDATE Horse<br>2 SET Height = 15.6<br>3 WHERE ID = 2;<br>4<br>5 UPDATE Horse<br>6 SET RegisteredName = 'Lady Luck', BirthDate = '2015-05-01'<br>7 WHERE ID = 4;<br>8<br>9 UPDATE Horse<br>10 SET Breed = NULL<br>11 WHERE BirthDate >= '2016-22-12';<br>12<br>13<br>14<br>15 -- Leave this query for testing<br>16 SELECT *<br>17 FROM Horse<br>18 ORDER BY ID;<br>

Extracted text: The Horse table has the following columns: • ID - integer, auto increment, primary key RegisteredName - variable-length string • Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be 2 10.0 and < 20.0="" •="" birthdate="" -="" date,="" must="" be=""> Jan 1, 2015 Make the following updates: 1. Change the height to 15.6 for horse with ID 2. 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. 3. Change every horse breed to NULL for horses born on or after December 22, 2016. 302990.1511538.gx3zgy7 LAB 12.16.1: Update rows in Horse table ACTIVITY Main.sql Load default 1 UPDATE Horse 2 SET Height = 15.6 3 WHERE ID = 2; 4 5 UPDATE Horse 6 SET RegisteredName = 'Lady Luck', BirthDate = '2015-05-01' 7 WHERE ID = 4; 8 9 UPDATE Horse 10 SET Breed = NULL 11 WHERE BirthDate >= '2016-22-12'; 12 13 14 15 -- Leave this query for testing 16 SELECT * 17 FROM Horse 18 ORDER BY ID;
Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here