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 vote207 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote200 views2 answers
How to save result of sqlite query in a table
SQL
2 votes176 views1 answer
Oracle sql drop table purge
SQL
0 vote189 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote307 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote201 views1 answer
Ssql to lowercqse
SQL
19 votes201 views6 answers
Sql drop table if exists
SQL
0 vote223 views1 answer
Sql show founctions
SQL
0 vote215 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote192 views2 answers
Find a column in all tables mysql
SQL