how to update data from share table

[hazahafiz]

hii to all..

actually in a database system,i have table user that some attribute share with system A and system B.
in case,i want to update attribute in table user that use for system A.
so,what the sql syntax that i will use to update related attribute with only once update?
how about this syntax:-

UPDATE <table name>
SET <attribute>
WHERE<condition query>

this syntax use for update one attribute only right??
in my situation i want to update more than one attribute.

please help me.

[vpmurdan]

Hi.
Am sorry if am being rude.
But do check some examples and you'll have your answer.
Do some homework.

an example below:

UPDATE persondata SET age=age*2, age=age+1;
 

prakash

[ronverdonk]

Have you ever had a look in the standard (available to anyone) MySQL documentation? That's where your answer is. Study UPDATE syntax

Ronald :cool: