UPDATE (SELECT t1.col1 c1, t2.col1 c2 FROM table1 t1, table2 t2

how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query

Question Posted / mglbayar

3 Answers
6471 Views
I also Faced
E-Mail Answers

Answer Posted / mglbayar

UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is left join faster than join?

1054

what are all the common sql function? : Sql dba

1058

What are the sql aggregate functions?

1134

What is the difference between a query and a report?

976

How do you exit in sql?

1111

What are the different ddl commands in sql?

1170

how to convert numeric values to character strings? : Sql dba

1108

What jobs use sql?

982

how do you login to mysql using unix shell? : Sql dba

1081

How do you rank data in sql?

1006

What is anonymous block in sql?

1121

What is sql engine in oracle?

992

What are the uses of merge?

1167

What does dml mean?

989

explain advantages of innodb over myisam. : Sql dba

1130