MySQL Basics In Pictures
Update records
  1. Type:

    UPDATE name SET party='Federalist' WHERE (last='Washington' OR last='Adams');

    then press ENTER.

    The UPDATE command fills in the blank entries in the name table that were created when you added the party field.

    This string of commands reads like this:

    UPDATE the table name. SET the party field to "Federalist" WHERE the last name of the president is either "Washington" OR "Adams."