arseniy and andrey
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, 'Ryan', 'M'), (2, 'Joanna', 'F'), (3, 'dan', 'F'), (4, 'bob', 'M'); update students set name='arseniy' where id = 2; -- fetch some values SELECT * FROM students;
Output
(Run the program to view its output)
Comments