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

1 vote365 views1 answer
What is in condition in sql
SQL
1 vote342 views1 answer
Select tables with name like mysql
SQL
1 vote335 views3 answers
Postgresql crete view
SQL
4 votes304 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
-1 vote375 views1 answer
Ms sql select datetime as date
SQL
33 votes405 views6 answers
Sql delete
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL
-2 votes328 views3 answers
Sqlite reset autoincrement
SQL
1 vote367 views2 answers
Sql server backup table
SQL
1 vote369 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL