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

3 votes135 views1 answer
Mssql remove column
SQL
0 vote155 views1 answer
SQL Server date literal
SQL
0 vote134 views1 answer
Mysql cdn link
SQL
2 votes149 views1 answer
Postgresql create schema in specific database
SQL
0 vote129 views1 answer
Deny select insert update delete sql
SQL
1 vote134 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote97 views1 answer
Alter session set nls_language french
SQL
1 vote148 views1 answer
Oracle index partition
SQL
0 vote193 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
6 votes138 views1 answer
What is where clause in sql
SQL