1

an anonymous user · October 14, 2021 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT ,
  gender TEXT 
);
-- insert some values
INSERT INTO students(id,name) VALUES (1, 'Ryan');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students;

Comments

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