With You can use the Hypothetical Here is an example that updates the customer address with ID 6: Now, the If you want to modify Now, the SQLite Of UPDATE The query is used to modify existing records in the table. You can use the WHERE Clause to update the selected rows, otherwise all rows will be updated. 1.18.1. Grammar ¶
WHERE Of the clause UPDATE The basic syntax of the query is as follows:UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];
AND Or OR Operator to combine N quantity conditions. 1.18.2. Example ¶
COMPANY The table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
sqlite> UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6;
COMPANY table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 Texas 45000.0
7 James 24 Houston 10000.0
COMPANY In the table ADDRESS And SALARY Column, you do not need to use the WHERE Clause, the query UPDATE is as follows:sqlite> UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00;
COMPANY table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 Texas 20000.0
2 Allen 25 Texas 20000.0
3 Teddy 23 Texas 20000.0
4 Mark 25 Texas 20000.0
5 David 27 Texas 20000.0
6 Kim 22 Texas 20000.0
7 James 24 Texas 20000.0