a question about "set"

[tsinghua2000]

gentleman:


now, I have a question about set , if only update one data item,
I know how to get the SQL sentence, that is :


for example:

update table set x=12

however, I don't know how to do , if update more than one data item

at same time.


update table set x=12 and set y=10 and set z=19.....

is that right?

who can tell me ........

[viptiger]

update table1
set x=12,y=10,z=19