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 vote147 views1 answer
Creating sqeuence in oracle database
SQL
1 vote115 views1 answer
Postgresql define pk sequence next number
SQL
1 vote119 views1 answer
Mysql curdate between two dates
SQL
0 vote107 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote111 views1 answer
When mysql server would not work in xampp
SQL
1 vote100 views1 answer
Local sql server
SQL
19 votes171 views5 answers
Mysql between date range
SQL
3 votes108 views1 answer
Two select sql
SQL
0 vote110 views1 answer
Hex string sql becomes int64
SQL
8 votes55 views2 answers
Alter column name in mssql
SQL