Students

Section $2\mathrm{.}17$ is a part of $1$ assignment: Module $2$ ZyLabs

Requirements:

zyLab

Due: $01/24/2024,11$:$59$ PM EST

$2\mathrm{.}17$ LAB $-$ Update rows in Horse table

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 $10\mathrm{.}0$ and $20\mathrm{.}0$

BirthDate $-$ date, must be $$ Jan $1,2015$

Make the following updates:

Change the height to $15\mathrm{.}6$ for horse with ID $2.$

Change the registered name to Lady Luck and birth date to May $1,2015$ for horse with ID $4.$

Change every horse breed to NULL for horses born on or after December $22,2016.$

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

$\backslash$table$[[$LAB$,2,17\mathrm{.}1$: LAB$-$Update rows in Horse table$]]$