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;
1UPDATE table_name
2SET column1 = value1, column2 = value2...., columnN = valueN
3WHERE [condition];
4
1Mit UPATE werden Datenwerte in der Datenbank aktualisiert. Nach Bedürfnis
2können auch mehrere Datensätze auf einmal verändert werden. Mit WHERE werden
3nur bestimmte Datensätze zu aktualisiert.
4
5 UPDATE suppliers
6 SET supplier_id = 50,
7 supplier_name = 'Apple',
8 city = 'Cupertino'
9 WHERE
10 supplier_name = 'Google';
11