Sql set

Sql update record

SQL> UPDATE CUSTOMERS
SET ADDRESS = 'Pune'
WHERE ID = 6;

Source: tutorialspoint.com

Sql set

Used alongside UPDATE to update existing data in a table.
Example: Updates the value and quantity values for an order with an id of
642 in the orders table.
UPDATE orders
SET value = 19.49, quantity = 2
WHERE id = 642;

Modifier une valeur sql

UPDATE table
SET nom_colonne_1 = 'nouvelle valeur'
WHERE condition

Source: sql.sh

Similar codes

0 vote189 views1 answer
Oracle list index on table
SQL
41 votes228 views6 answers
Alter table add column in SQL Server
SQL
4 votes185 views1 answer
Select nls_date_format
SQL
0 vote194 views1 answer
Function sum(text) does not exist postgres
SQL
2 votes225 views3 answers
Row number mysql
SQL
0 vote226 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
2 votes185 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote196 views1 answer
Oracle remove line breaks
SQL
2 votes219 views2 answers
How to run postgresql in linux
SQL
0 vote197 views2 answers
Sql update multiple tables
SQL