Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6310 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
How do I delete a trigger?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Which join is like inner join?
How do I truncate a sql log file?
What is nvarchar in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Which are the different case manipulation functions in sql?
what are enums used for in mysql? : Sql dba
How do I know if I have sql express or standard?
What is cross join example?
explain access control lists. : Sql dba
what is clause? : Sql dba
What is difference between inner join and cross join?
Why stored procedure is faster than query?
How do you use collections in procedure to return the resultset?
