sereza

an anonymous user · January 26, 2023
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES
    (1, 'Ryan', 'M'),
    (2, 'Joanna', 'F'),
    (3, 'God', 'M'),
    (4, 'Mike', 'M');
UPDATE students
    SET name = 'Sereza'
    WHERE id = 2;
-- fetch some values
SELECT id,name FROM students /*WHERE id >= 4-2 and gender = 'M';*/

Output
(Run the program to view its output)

Comments

Please sign up or log in to contribute to the discussion.