How do you modify data already in the database? You could use DELETE to remove the row, then INSERT to insert an new row, but that is quite inefficient. The UPDATE command allows you to update data already in the database. It follows a format similar to the previous commands.
Mike had a birthday, so we want to update his age in this table. Figure
shows an example.
Notice that the Mike row has moved to the end of the list. The next section will show you how to control the order of the row display.