SQL update query

Question

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

update tablename set field1= val1where id=1

now i want to update 2 fileds as follows .How can i do that?

update tablename set field1 =val1 and set fied2=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

Answer 2

You almost had it:

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

Answer 3

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

COMMIT;

Answer 4

UPDATE  TableName
SET     Field1=Value1
       ,Field2=Value2
WHERE   id=id_value

Like the others, but this is how I like to indent and format it, on bigger complex queries, proper formating matters alot!

Answer 5

Or to be safe, I like to write UPDATE statements like this:

UPDATE T
SET
    T.Field1 = Value1
    ,T.Field2 = Value2
-- SELECT *
FROM TableName AS T
WHERE T.ID = 1

This way you can be sure of what you'll be updating.