Skip to content

Instantly share code, notes, and snippets.

@isaacharrisholt

isaacharrisholt/why_learn_sql.sql

Created October 8, 2022 12:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save isaacharrisholt/32bdfa496877dda2c395bb32278dae2d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save isaacharrisholt/32bdfa496877dda2c395bb32278dae2d to your computer and use it in GitHub Desktop.
Download ZIP
The SQL used to generate the tables
Raw
why_learn_sql.sql
CREATE TABLE users (
id INTEGER NOT NULL,
name VARCHAR(50),
PRIMARY KEY (id)
);
CREATE TABLE orders (
id INTEGER NOT NULL,
user_id INTEGER,
description VARCHAR(50),
payment_status BOOLEAN,
PRIMARY KEY (id),
FOREIGN KEY(user_id) REFERENCES users (id)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment