SQLite UPDATE Query

In SQLite, UPDATE query is used to modify the existing records in a table. It is used with WHERE clause to select the specific row otherwise all the rows would be updated.

Syntax:

snippet
UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

Example:

We have an existing table named "STUDENT", having the following data:

Sqlite Update query 1

Example1:

Update the ADDRESS of the student where ID is

snippet
UPDATE STUDENT SET ADDRESS = 'Noida' WHERE ID = 1;
Sqlite Update query 2

Now the address is updated for the id 1. You can check it by using SELECT statement:

snippet
SELECT * FROM STUDENT;

Output:

Sqlite Update query 3

Example2:

If you don't use WHERE clause, it will modify all address in the STUDENT table:

snippet
UPDATE STUDENT SET ADDRESS = 'Noida';

Output:

Sqlite Update query 4
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents