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 vote277 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
3 votes290 views1 answer
Sql multi column index performance
SQL
1 vote298 views3 answers
Update from select sqlite
SQL
0 vote292 views1 answer
Postgres copy command
SQL
5 votes329 views1 answer
Get column name sql server
SQL
0 vote293 views2 answers
Sql join on comma separated field
SQL
17 votes297 views3 answers
Postgresql version command
SQL
0 vote279 views1 answer
Replace \n sql
SQL
0 vote328 views1 answer
Postgresql custom order by
SQL
0 vote352 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL