update tablename set field1=value1, field2=value2, ... where field= value;