Skip to content

Instantly share code, notes, and snippets.

@pamelafox

pamelafox/animals.sql

Created November 22, 2021 21:11
Show Gist options
  • Save pamelafox/f6cd534b5042923e2d8463a485663eb0 to your computer and use it in GitHub Desktop.
Save pamelafox/f6cd534b5042923e2d8463a485663eb0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. pamelafox created this gist Nov 22, 2021.
    8 changes: 8 additions & 0 deletions animals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    CREATE TABLE animals (name TEXT, legs INTEGER, weight INTEGER);

    INSERT INTO animals VALUES ("dog", 4, 20);
    INSERT INTO animals VALUES ("cat", 4, 10);
    INSERT INTO animals VALUES ("ferret", 4, 10);
    INSERT INTO animals VALUES ("parrot", 2, 6);
    INSERT INTO animals VALUES ("penguin", 2, 10);
    INSERT INTO animals VALUES ("t-rex", 2, 12000);