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

15 votes199 views3 answers
Mysql update add to existing value
SQL
1 vote206 views1 answer
Oracle sql pad left zeros
SQL
0 vote145 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote192 views1 answer
Change role postgres
SQL
0 vote240 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes200 views1 answer
Mysql id of inserted row
SQL
0 vote201 views1 answer
TSQL convert csv to table
SQL
2 votes234 views1 answer
Remove foreign key constraints in postgres
SQL
12 votes194 views1 answer
How to change the value of a table in sql
SQL
1 vote222 views1 answer
Sql order by timestamp
SQL