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 vote242 views1 answer
Mysl like insert a variable
SQL
10 votes178 views1 answer
Create table oracle
SQL
0 vote168 views1 answer
How to count null values in sql
SQL
3 votes189 views2 answers
Tsql join multiple record in one string
SQL
0 vote172 views1 answer
Default value false mysql
SQL
0 vote183 views1 answer
Mysql update from n to 100
SQL
0 vote181 views1 answer
Syntax for changing column size in mysql
SQL
0 vote185 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
8 votes188 views4 answers
Postgresql server restart
SQL
3 votes229 views4 answers
Postgresql change timezone on timestamp without timezone
SQL