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 vote281 views1 answer
Sql counter column
SQL
0 vote306 views1 answer
Primary key multiple colums
SQL
1 vote274 views1 answer
Delete mysql from mac
SQL
0 vote316 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote303 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote288 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote282 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote293 views2 answers
Update information in a mysql column
SQL
7 votes296 views2 answers
Create index mysql cli
SQL
4 votes365 views3 answers
Mysql get column names from table
SQL