YouTip

# SQLite UPDATE Statement SQLite's **UPDATE** query is used to modify existing records in a table. You can use an UPDATE query with a WHERE clause to update selected rows; otherwise, all rows will be updated. ## Syntax The basic syntax of an UPDATE query with a WHERE clause is as follows: UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE ; You can combine N number of conditions using the AND or OR operators. ## Example Assume the COMPANY table has the following records: ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------1 Paul 32 California 20000.02 Allen 25 Texas 15000.03 Teddy 23 Norway 20000.04 Mark 25 Rich-Mond 65000.05 David 27 Texas 85000.06 Kim 22 South-Hall 45000.07 James 24 Houston 10000.0 Here is an example which will update the address for a customer whose ID is 6: sqlite> UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6; Now, the COMPANY table will have the following records: ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------1 Paul 32 California 20000.02 Allen 25 Texas 15000.03 Teddy 23 Norway 20000.04 Mark 25 Rich-Mond 65000.05 David 27 Texas 85000.06 Kim 22 Texas 45000.07 James 24 Houston 10000.0 If you want to modify all ADDRESS and SALARY column values in the COMPANY table, you do not need to use the WHERE clause. The UPDATE query would be as follows: sqlite> UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00; Now, the COMPANY table will have the following records: ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------1 Paul 32 Texas 20000.02 Allen 25 Texas 20000.03 Teddy 23 Texas 20000.04 Mark 25 Texas 20000.05 David 27 Texas 20000.06 Kim 22 Texas 20000.07 James 24 Texas 20000.0