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
- 6362 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
explain the difference between myisam static and myisam dynamic. : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
What is a file delimiter?
Why do we create stored procedures & functions in pl/sql and how are they different?
Are stored procedures faster than dynamic sql?
what is top in tsql? : Transact sql
how can we submit a form without a submit button? : Sql dba
What is rename command in sql?
How to select 10 records from a table?
what are the 'mysql' command line arguments? : Sql dba
Why are indexes and views important to an organization?
What does fetching a cursor do?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is asqueryable?
How do you select unique values in sql?
