You can also do this through the query window or command line. You have to be very careful when updating records this way and double check your syntax, as it is very easy to inadvertently overwrite several records.
UPDATE people SET age = 7, date = "2006-06-02 16:21:00", height = 1.22 WHERE name = "Peggy"
What this does is update the table "people" by setting new values for age, date, and height. The important part of this command is WHERE, which insures that the information is only updated for Peggy and not for every user in the database.


