-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  phone INTEGER NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', '12345');
INSERT INTO students VALUES (2, 'Joanna', 'F','1245');
-- fetch some values
update students set phone = '23456' where id = 2;
SELECT * FROM students