5.2 Unit 4 Lab 2 The Horse table has the following columns: • ID-integer, auto increment, primary key RegisteredName-var

[answerhappygod]

5 2 Unit 4 Lab 2 The Horse Table Has The Following Columns Id Integer Auto Increment Primary Key Registeredname Var 1 (54.75 KiB) Viewed 30 times

5.2 Unit 4 Lab 2 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 a 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. NOTE: Starter code has been provided. Simply change the blanks () to the appropriate entity/value. 411318027341507 LAN ACTIVITY 52.1: Unit 4 Lab 2 Change the height to 15.6 for horse with ID 2. UPDATE Horse SET Height WHERE ID23 15.6 14 6 Change the registered nose to Lady Luck and birth date to May 1, 2015 for norse with ID 4. 7 UPDATE SET 9 WHERE Main.sql NULL 16 11 Change every horse breed to NULL for horses born on or after December 22, 2016. 12 UPDATE 23 SET 14 WHERE 2016-12-221 2015-05-01 0/10 Load defaut templa