Таблица кайфариков

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, 'Bob Marlya', 'M'),
 (2, 'Joanna', 'F'),
 (3, 'Nurgeyskiy', 'G'),
 (4, 'Cheef Kiev', 'M');
 update students
 set gender = "N"
 where id = 2;
 update students
 set name = "maslenok"
 where id = 2;
-- fetch some values
SELECT * FROM students;
Output
(Run the program to view its output)

Comments

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