learn.zybooks.com$/$zybook$/$Database$\_$Essentials$\_$for$\_$Business$\_$with$\_$Lab$\_\_\_11506/$chapter$/2/$section$/12$

My library $>$ BIS $245$: Database Essentials for Business with Lab home $>$

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

zyBooks catalo

$2\mathrm{.}12$ 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.

LAB

ACTIVITY

$2\mathrm{.}12\mathrm{.}1$: LAB $-$ Update rows in Horse table

Search

Main.sql