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 votes319 views1 answer
MySQL DELETE JOIN
SQL
0 vote327 views1 answer
Datagrip execute procedure
SQL
0 vote311 views1 answer
Test connection to sql server
SQL
0 vote289 views1 answer
Full syntax inner join
SQL
0 vote333 views1 answer
Generate random & unique mysql string
SQL
0 vote320 views1 answer
Select multiple row from primary key sql
SQL
0 vote332 views2 answers
Greater than sql server
SQL
0 vote315 views1 answer
Désinstaller postgresql linux
SQL
0 vote355 views1 answer
Python sqlalchemy connection show server
SQL
1 vote346 views3 answers
Union SQL
SQL