1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition;
1UPDATE YourTable
2SET Col1 = OtherTable.Col1,
3 Col2 = OtherTable.Col2
4FROM (
5 SELECT ID, Col1, Col2
6 FROM other_table) AS OtherTable
7WHERE
8 OtherTable.ID = YourTable.ID
1-- sql update using string format
2String = "UPDATE yourtable SET yourcolumn = '" + yourvealueintext + "' WHERE column = " + item_to_compare_the_position_of_Your_Column;
3 -- or
4String = "UPDATE yourtable SET yourcolumn = " + yourvalue_in_number + " WHERE column = " + item_to_compare_the_position_of_Your_Column;