Select in Update Query
Update and Select:
For Update a table’s record with the other record which is present in another table, we can use,
UPDATE table1 SET field1 = (SELECT field1 FROM table2 WHERE condition1 ) WHERE condition2
If we want to update in same table,we can use variable.
SET @var1= SELECT field1 FROM table1 WHERE condition1;
UPDATE table1 SET field 1 =@var1 WHERE condition2;
