sereza
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, '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