--update query example UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
UPDATE Table_A SET Table_A.col1 = Table_B.col1, Table_A.col2 = Table_B.col2 FROM Some_Table AS Table_A INNER JOIN Other_Table AS Table_B ON Table_A.id = Table_B.id WHERE Table_A.col3 = 'cool'
UPDATE Customers SET ContactName='Juan' WHERE Country='Mexico';
UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];
SQL> UPDATE CUSTOMERS SET ADDRESS = 'Pune' WHERE ID = 6;
UPDATE Student SET NAME = 'PRATIK';