Таблица кайфариков
an anonymous user
·
-- 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