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:
Example:
We have an existing table named "STUDENT", having the following data:
Example1:
Update the ADDRESS of the student where ID is
Now the address is updated for the id 1. You can check it by using SELECT statement:
Output:
Example2:
If you don't use WHERE clause, it will modify all address in the STUDENT table:
Output:
No comments:
Post a Comment