SQL update query

Question

I want to update two fields in one sql query. How do I do that?

update tablename set field1= val1 where id=1

Now I want to update 2 fields as follows: How can I do that?

update tablename set field1 =val1 and set field2=val2 where id=1

Answer 1

Your syntax is almost correct, but you can't use AND.

UPDATE tablename SET field1=var1, field2=var2 WHERE id=1