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 vote152 views1 answer
How change the field place in mysql
SQL
15 votes180 views5 answers
Select all tables sql
SQL
1 vote154 views2 answers
Pad zero sql server
SQL
0 vote181 views1 answer
IS THEre any difference between using default and := in plsql
SQL
4 votes193 views6 answers
Select sql
SQL
0 vote163 views1 answer
MySql get primary keys of table
SQL
0 vote171 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote165 views2 answers
Python mysql create table if not exists
SQL
2 votes190 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote163 views8 answers
Convert sql query to linq online
SQL