update statement like insert statement takes 3 arguments. table_name is the name of the table you want to update, field1 is the name of the field ( column ) whose value you want updated and 'new value' is the new value that field1 will contain. Note where clause is optional, it is used to pick one specific record to update from the whole column.
