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