SQLite UPDATE Statement

SQLite UPDATE Statement

The SQLite UPDATE Statement is used to modify the existing data in a table. We can use the WHERE clause to identify the row(s) and update the respective columns with new data.

Syntax

The general syntax of the UPDATE statement is as follows:

To update a single column:

UPDATE table_name
SET column1 = value1
WHERE <condition>;

To update multiple columns:

UPDATE table_name
SET column1 = value1, column2 = value2…., columnN = valueN
WHERE <condition>;

Example

Example to update a single column:

In this example, we will modify James Smith’s bonus to $500 using the UPDATE statement.

sqlite> UPDATE emp
…> SET bonus=500
…> WHERE empno = 3;
sqlite>

We used the table’s PRIMARY KEY empno to identify the employee record uniquely. James Smith’s empno is 3 in the emp table.

We can verify the modification using the SELECT statement.

Example to update multiple columns:

In this example, we will update Emma Johnson’s new role and salary after promotion. Her new role is Sr. Manager, and her new salary is $ 28,000.

sqlite> UPDATE emp
…> SET jobtitle = ‘Sr MANAGER’, salary = 28000.00
…> WHERE empno = 2;
sqlite>

The next example is to update a single column and all table rows.

Write the update statement to update the bonus of all the employees in the emp table to $ 1000.

sqlite> UPDATE emp
…> SET bonus=1000;

All rows will be updated when we omit the WHERE clause in the UPDATE statement. We can also specify the obvious true condition in the WHERE clause.

sqlite> UPDATE emp
…> SET bonus=1000
…> WHERE 1 = 1;

SQLite Tutorials

SQLite tutorials on this website:

https://www.testingdocs.com/sqlite-database-tutorials/