Create

an anonymous user · February 23, 2021 ·

SQL

Code
Input
Output

-- 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');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

Click on the Run button to get started.

The code/input has changed since you last clicked on Run. Click it again to see the updated changes.

Comments

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