Update data in table using update statement.

 Update data in table using update statement.

CREATE TABLE students (

  id INTEGER primary key,

  name TEXT ,

  gender TEXT

);

-- insert some values

INSERT INTO students VALUES (1, 'Ryan', 'M');

INSERT INTO students VALUES (2, 'Joanna', 'F');

update students set name='john' where id='1';

-- Ryan was now changed to John

SELECT * FROM students;

1|john|M
2|Joanna|F