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 vote202 views1 answer
Add user mysql wordpress
SQL
0 vote140 views1 answer
Dockerfile example for Django
SQL
0 vote152 views1 answer
How to to get time in sql
SQL
0 vote138 views1 answer
Time mysql w3
SQL
2 votes121 views1 answer
Mysql find tables with name
SQL
0 vote133 views1 answer
How to put value in parameters in mysqldataadapter
SQL
2 votes124 views2 answers
Get all tables using like
SQL
20 votes129 views2 answers
Mysql bigint max value
SQL
0 vote119 views4 answers
Forenkey code alchemy sql
SQL
0 vote126 views1 answer
Postgres : ERROR: division by zero
SQL