Inserting Data - Learning MySQL and MariaDB - page 137

place that row with a new value for the body_shape column. Replace it with
Upland Ground Birds . To do this, use the REPLACE statement, covered in Repla-
cing Data . In the VALUES clause of the REPLACE statement, provide the same
value previously set for the body_id so that it is not lost.
After you enter the REPLACE statement, execute a SELECT statement to retrieve
all the rows of data in the birds_body_shapes table. Look how the data
changed for the row you replaced. Make sure it's correct. If not, try again either
using REPLACE or UPDATE .