dariya

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', 'M'),
   ( '3', 'God', 'M'),
   ( '4', 'Milka', 'M');
update students
set name = 'Dariya'
where id = 2;
-- fetch some values
SELECT * FROM students/*WHERE gender = 'F';*/
Output
(Run the program to view its output)

Comments

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